On 12/13/2011 11:31 AM, Rafael Garcia Leiva wrote:
The problem is that is veeeeery slooooow. It takes nearly 24 hours to query 1 year of Forex data in my laptop (and I have to work with 10 years periods). I will spend a couple of days learning about sqlite optimization.
I suspect these two days would be better spent writing a script that just scans through the records in chronological order, with hand-written code to summarize them the way you need. It would be an order of magnitude faster than anything you could come up with in pure SQL.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
