"Zahraie Ramin-p96152" <[EMAIL PROTECTED]> writes: >> Did you tried with easier queries? (select * from >> dvrpAudioFileTable) ? >> Also in this case you have such times? >> >> 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?
The sqlite command line tool *uses* the APIs. Why don't you take a look at the source for the sqlite command line tool, and see what it's doing differently than you are. There's clearly _something_ different; it's just a matter of tracking it down. You should find the code remarkably similar to what you're already doing. Derrell
