Dilly Tools

Hm, nope I didn't consider that. Thanks a lot for the suggestion. :)
I'm not sure whether this would work for me or not, though. I would have to predefine on what I want to base those vectors around. It'll be 7food spots most likely but if someone is looking for something different for whatever reason I won't find it. Or I'd have to build vectors for all 7-resource spots which on the other hand would most likely result into having more database entries than I would have with simply loading the whole map into the database.

My current approach is very open and you can define all variables.
So far it takes only a couple of minutes to perform a search for a whole region. As soon as I get my Odroid (and install a database on it) it should be a lot faster.
Then I know for sure how fast my approach is. If it doesn't match my expectations I'll look for another solution. :)


Edited by Digioso - 09 Mar 2015 at 16:35

I'm using the approach to search for high resource spots with nearby spots with 7food (or rather: an amount of resources you can configure) to narrow down the total number of fields I've got to search.

And yep, I'm using Perl as well. My database will be MySQL. I've got most experience with MySQL and Oracle databases but Oracle is a bit too expensive. :)

Oh, I didn't know that. Won't keep me from working on my tool I guess, though. I like to finish things I started. :)

I managed to add all Sov bonusses (resources and stuff like +x% Beer production).
So far it's not possible to specify the latter as a search criteria (EG: The new spot should have +6% Beer production in the first ring around the city) but I'm working on that.

On the topic on displaying Sov bonusses (resources and the other production bonusses):
What would you prefer?
a) It displays the specific bonusses per ring around your city (like in http://www.digioso.org/Tamarin_new.htm)
b) It sums up the total bonusses. EG Ring 2 = All bonusses from Ring 1 + All Bonusses from Ring 2 (like in http://www.digioso.org/Tamarin.htm)

My Odroid has not arrived yet unfortunately... But I hope it'll be here soon. Then I can open this to the public.


Edited by Digioso - 08 Mar 2015 at 06:55

Well, it's not that my webspace is free or anything. I have to pay for it of course. Sure, I've got some ads there but frankly speaking they pay for like 0,01% of the costs. :P
So yes, I don't have a dedicated server with lots of power there. It's shared webspace, nothing more, nothing less. I'm using it as my private website, providing stuff that's free to use by anybody. It's not for a company or to make money. Of course it would be nice to earn enough money to make a living from that, but I'm pretty sure I won't be a second Google anytime soon.
So yes, I'm giving my spare time and cash for free here. You offered that you might be able help. I said that would be great. I didn't explictly ask for help in the first place. :)

Well, anyway, back to topic I'd say. :)
I think I found a pretty neat solution for the runtime memory consumption by pre-filtering the data I process. Let's see how that works out. Most likely it's not fast enough for a web application but, well, let's see.

Edit:
The time to scan a region is now down to a couple of minutes. Before it took between 30min and 1h. :)


Edited by Digioso - 23 Feb 2015 at 20:02