> Is their a way to prepare the query and save (compiled form) so that we can > share them between multiple connection?
Yes, there is: http://sqlite-consortium.com/products/sse. Pavel On Mon, Oct 12, 2009 at 6:28 AM, Naveen Grover -TP <naveen.gro...@igt.in> wrote: > Is their a way to prepare the query and save (compiled form) so that we can > share them between multiple connection? > > Regds, > Naveen > > -----Original Message----- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jay A. Kreibich > Sent: Sunday, October 11, 2009 1:54 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] sqlite in-memory database far too slow in my use case > > On Sat, Oct 10, 2009 at 07:24:33PM +0200, Ron Arts scratched on the wall: > >> I'm afraid the process of >> constructing SQL queries / parsing them by sqlite, and >> interpreting the results in my app, multiple times per >> event will be too slow. > > There should be no need to construct and parse queries with each > interaction. Assuming the queries are fairly well known, you should > be able to prepare them once and then keep using them over and over. > This should save a noticeable amount of time. > > Make sure you're using the prepare/bind/step/reset/finalize > interfaces, rather than exec or get_table. > > -j > > -- > Jay A. Kreibich < J A Y @ K R E I B I.C H > > > "Our opponent is an alien starship packed with atomic bombs. We have > a protractor." "I'll go home and see if I can scrounge up a ruler > and a piece of string." --from Anathem by Neal Stephenson > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > +++++++++++++++++++++++++++++++++++++++++ > CONFIDENTIALITY NOTICE & DISCLAIMER > > The contents of this e-mail are confidential to the ordinary user of the > e-mail address to which it was addressed and may also be privileged. If you > are not the addressee of this e-mail you may not copy, forward, disclose or > otherwise use it or any part of it in any form whatsoever. If you have > received this e-mail in error please e-mail the sender by replying to this > message. The recipient should check this email and any attachments for the > presence of viruses. InterGlobe accepts no liability for any damage caused by > any virus transmitted by this email. > +++++++++++++++++++++++++++++++++++++++++ > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users