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);
SQLite Admin does it in 47ms and the CPP code takes 140 ms
Wonder what could be wrong ?
-Ady
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
