Re: [sqlite] SQLite Step Function

2008-05-28 Thread Stephen Oberholtzer
On Wed, May 28, 2008 at 12:32 AM, sqlite <[EMAIL PROTECTED]> wrote: > > Dear Stephen, > > Thanks for the reply. As you said we checked the EXPLAIN QUERY PLAN with > our > query and it has shown that all the four tables we use in the query are > using their indexes and there is no ORDER BY class

Re: [sqlite] SQLite Step Function

2008-05-27 Thread sqlite
Dear Stephen, Thanks for the reply. As you said we checked the EXPLAIN QUERY PLAN with our query and it has shown that all the four tables we use in the query are using their indexes and there is no ORDER BY class in our query. So sqlite3_prepare compiles the query and sqlite3_step executes the