hello,
we have noticed that executing a select query in SQLite expert is 3 times as
fast as executing it using our own C++ application. This seems quite odd as we
are doing no funky stuff in the code, the sqlite3_step alone in our app takes
longer then the entire process in (compiling the query, executing it, and
showing the results) does in SQLIte Expert.
Does SQLite Expert do something special?
We use the following pragma's:
Pragma encoding = 'UTF-16'
Pragma page_size = 4096
PRAGMA foreign_keys = ON
thanks in advance,
Gert
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
