On Fri, Jan 14, 2011 at 1:18 PM, Vander Clock Stephane <
svandercl...@yahoo.fr> wrote:

> it's not enalf :(
>
> > Read the file!
> >
>

If you know your queries in advance and it's some SELECT you can create a
temporary query wrapped into "SELECT COUNT(*) FROM (your select here)" and
execute it when the program starts. In this case you don't have to save this
temporary result (it's a single row and single column) and the system and
sqlite will read the same parts of the file that will be needed later.

Max Vlasov
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to