Hi, I found sqlite is kind of slow on windows (2003 server and XP professional). Here is what i did: 1) downloaded and installed sqlite3.dll (version 3.6.5). 2) created a MSVC 6.0 C++ projects with the following code, which basically runs a list of SQL statments on a opened database: #include <stdio.h> #include "pctimer.h" #include "sqlite3.h" int main(int argc, char** argv) { int ret; double start, duration; char* error = NULL; char* database_name = "test.dat"; sqlite3* database = NULL; ret = sqlite3_open(database_name, &database); char* sql_list[] = { "create table if not exists t1(f1)", "insert into t1 values('a')", "select * from t1", "drop table if exists t1" }; for (int i = 0; i < 4; i++) { TIME(ret = sqlite3_exec(database, sql_list[i], NULL, NULL, &error), 1000); printf("sql_list[%d] = %d, %f msec\n", i, ret, duration); } sqlite3_close(database); return 0; } in "pctimer.h" #define TIME(Statement, Unit) start = pctimer(), Statement, duration = (pctimer() - start) * Unit #include <windows.h>
__inline pctimer_t pctimer() { static LARGE_INTEGER pcount, pcfreq; static int initflag; if (!initflag) { QueryPerformanceFrequency(&pcfreq); initflag++; } QueryPerformanceCounter(&pcount); return (double)pcount.QuadPart / (double)pcfreq.QuadPart; } Here is a typical outputs from the program running in debug mode: sql_list[0] = 0, 115.522582 msec sql_list[1] = 0, 146.979062 msec sql_list[2] = 0, 0.152468 msec sql_list[3] = 0, 127.423370 msec The "create table", "insert into" and "drop table" are slower than I expected whereas the "select" is ok (compared to published sqlite performance). I tried turning off antivirus but got the same results. Notice my constraint is these SQL statements must run one by one, not within a transaction. My questions are: 1) are these expected performance on windows? 2) if not, what can be done to improve it? Many thanks in advance. FLX _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users