"Farzana" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > We are working in eVC++ environment with SQLite database. > We are using the functions sqlite3_prepare and sqlite3_step to > execute the query. While passing the sqlite3_prepare step its taking > some time whereas after passing this step the other functions are > quite fast.
Is this the very first SQLite call after sqlite3_open? The first call needs to read and cache database schema, and so it takes an atypically long time. Warm up the connection first before doing any measurements, if you want to measure the steady state and not one time start-up effects. Also, for complex queries it is not unusual that preparing the query (parsing, figuring out the execution plan, optimizing) may take longer than actually executing it. This is precisely why you are given an option to prepare a statement once and then execute it many times. Finally, see http://www.mail-archive.com/sqlite-users@sqlite.org/msg30073.html Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
