SQLite Forum

long runtime for sqlite3_prepare_v2
Login
Hi All,

We are using the C++ interface of sqlite to create and populate databases.  What we have noticed is that it takes about 10-20 sec ( depending on machine - Linux server machines) to execute one sqlite3_prepare_v2() command per database.

Our questions are:

1. Is this expected or something that is can be done to improve it ( we are compiling our own sqlite3.
2. The command we are preparing is identical for many databases, is there any way to prepare once and reuse for different databases?