> -----Original Message----- > From: Griggs, Donald [mailto:[EMAIL PROTECTED] > Sent: Friday, September 03, 2004 3:56 PM > To: [EMAIL PROTECTED] > Subject: RE: [sqlite] One more question on the C API performance > > > Regarding: "... why the complex query takes x milliseconds > to execute from > > the sqlite command line but it takes 15 seconds with the APIs?" > > > If you were to double the timeout limit, does the query then > require 30 > seconds? > If so, that would certainly point to a timeout you're experiencing. >
Thank you Donald and Derrell for your suggestions. Derrell's in particular, made me think about the version of sqlite DLL I was using. The version that I had was dated 3/31/2004. I downloaded a version from sqlite.org where the creation date is 7/22/2004. That solved the problem as now it takes only 0.5 second to return 1000 rows of data! :) Once again thank you all immensely for all the help and suggestions that you provided. Regards
