On 13 Nov 2013, at 10:45pm, L. Wood <lwoo...@live.com> wrote: > If a single _step() call takes a long time to execute (a few minutes),
A few minutes is extremely unlikely. You'd have to be doing OFFSET 500000 or doing an ad hoc request which needs to make up its own index for a table of a few million rows. If none of your tables are longer than 100000 rows and you have half-way decent indexes just don't worry about it. > is my only option to just wait for it? Don't forget step is spending most of its time doing calculations and accessing disk cache. You're probably not going to save much time if your computer has to multitask. Write your code first. Run it. Only then if it's too slow worry about optimization. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
