Just got back from watching The Pharaoh Serket and the Stone of Fire. A bunch of us went to see Whitney's play at the Seattle Children's Theatre. It was very very good, with the sets and changes being some of the best parts. 

Market Analysis Tool

The database has 77k orders in it. I just ran the Trade Finder looking for deals worth more than 10M ISK assuming I'm flying a Badger and have 50M ISK to trade with. This would give me a 20% return on investment!

The script pared 298k deals in 2 1/2 minutes and found 626 transactions that made more than 10M ISK. Many of these were Isogen or Noxium but a few were for Capacitor Consoles, and there were worth in the 15M-17M range. Though I haven't checked to see if they are in low sec or very far apart.

End result? The finder works, it may take some time but it does complete in the less than 5 minutes I was aiming for. Will have to see how it holds up as the database gets larger. Adding a function to exclude orders older then X hours would help with day to day stuff. Plus I could have it auto find every so many minutes or just for those orders that get imported each time? That last bit would be very slick. Maybe maintain a priority database of orders that is updated every every few minutes? Then when hit by a user it would just parse this list and use the users data? 

Not sure how I would implement that. Would I have to hard code the capacity and a minimum ISK value? That would assume the user would not have more ISK or cargo capacity. Just some thoughts. In the end this could make it faster but might miss some trades?

This weekend I hope to work on Dijkstra. But tomorrow might end up being Rock Band...

(BTW I have enabled comments, didn't know I needed to)