SQLite Forum

long runtime for sqlite3_prepare_v2
Regarding "Is \[10-20 second sqlite3_prepare_v2() execution time\] expected\[?\]":

No expectations can reasonably exist absent some knowledge of the input. If the input is short, why not post it?  If it is ridiculously long, maybe it *should* take awhile to compile.

Regarding "is any way to prepare once and reuse for different databases?":

Not in the present library code.