On Tue, Nov 1, 2011 at 6:25 PM, Tal Tabakman <tal.tabak...@gmail.com> wrote:
> I have a slowness problem when running sqlite3 based application.
> I have a small db (500 K on disk, only 10000 rows) and I have a loop that
> perform 10000 selections according to
> the primary key of a certain table.
> for some reason in takes 15-20 seconds to run the loop below.
> by experimentation I found that this issue is related to the use of
> sqlite3_reset. i.e, by creating a new statement in every loop iteration
> without reseting and reusing it I got good performance (took a
> second,needless to say that I want to avoid this since it causes mem
> leaks.)
> any idea why sqlite3_reset has such a bad performance impact on my program
> ?
>
Please try the change below and let us know how it helps.
>
> int main() {
> sqlite3 * handle;
> sqlite3_stmt * m_entrySelectSnumStmt;
> sqlite3_open("entries.db",&handle);
> std::ostringstream query;
> query << "SELECT * FROM entries where SNUM = ? LIMIT 1;";
> sqlite3_prepare_v2(handle, query.str().c_str(),
> query.str().length()+1, &m_entrySelectSnumStmt, 0);
>
sqlite3_exec(handle, "BEGIN", 0, 0, 0);
> for(int i = 0; i < 10000; i ++){
> sqlite3_bind_int(m_entrySelectSnumStmt,1,i);
> int rc = sqlite3_step(m_entrySelectSnumStmt);
> sqlite3_clear_bindings(m_entrySelectSnumStmt);
> sqlite3_reset(m_entrySelectSnumStmt);
> }
>
sqlite3_exec(handle, "COMMIT", 0, 0, 0);
> }
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
