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
