> -----Original Message----- > From: Paolo Vernazza [mailto:[EMAIL PROTECTED] > Sent: Friday, September 03, 2004 2:03 PM > To: [EMAIL PROTECTED] > Subject: Re: [sqlite] One more question on the C API performance > > > > >The query takes about 19 seconds at best to complete. Does > anyone know why there is such a discrepancy? > > > >Thanks very much in advance. > > > Did you tried with easier queries? (select * from > dvrpAudioFileTable) ? > Also in this case you have such times? > > Paolo >
Hi Paolo Thanks for the suggestion. This query took only 180 milliseconds. The question is why the complex query takes x milliseconds to execute from the sqlite command line but it takes 15 seconds with the APIs? Thanks again and take care. RZ
