Have you timed the entire application instead of just the SQL query?
Put both apps inside a system() call and time those.
Are you sure they are both compiled with the same optimization?
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
________________________________
From: sqlite-users-boun...@sqlite.org on behalf of ady
Sent: Mon 9/20/2010 7:49 AM
To: sqlite-users@sqlite.org
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 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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
