On Jan 22, 2009, at 6:33 PM, Igor Tandetnik wrote: > Derek Developer > <derekdevelo...@yahoo.com> wrote: >> I am using >> sqlite3_prepare_v2() >> to process my SQl queries. This takes around 80% of the processing >> time compared to recovering the result set. >> >> Once the querire has been processed i can obviously provide a >> progress bar when stepping through the result set, but what progress >> indication is available during the prepare stage? > > What kind of query do you have that it takes more than a few > milliseconds to prepare - long enough that you feel a progress > indicator > is necessary?
I'm guessing that the sqlite3_prepare() that is taking a long time is the first one since the database connection was opened and that there is a huge schema to be parsed. Derek: How big is your schema? > > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users