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

[ady]

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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users