Re: [sqlite] SELECT is Slow when run in C++ code compared to SQLite Administrator

Hello ady, I'd hazard a guess that SQLite Admin does something that caches the file data in memory. If you do the select twice in a row. How fast is it the second time on the C++ code? I've found that opening the DB file using regular windows calls and simply reading it to the end, closing it an

Re: [sqlite] sqlite] SELECT is Slow when run in C++ code compared to SQLite Administrator

From: [email protected] on behalf of ady Sent: Mon 9/20/2010 7:49 AM To: [email protected] Subject: EXTERNAL:[sqlite] SELECT is Slow when run in C++ code compared to SQLite Administrator Hi I have found that a select is slow when run through

[sqlite] SELECT is Slow when run in C++ code compared to SQLite Administrator

Hi I have found that a select is slow when run through C++ code compared to SQLite Administrator I am executing SELECT * FROM docs WHERE (mail_index MATCH ('*FirstRun')) ORDER BY CREATED_TIME DESC int nRet = sqlite3_prepare(mpDB, szSQL, -1, &pVM, &szTail); nRet = sqlite3_step(pVM); SQ