Thank you very much for reply. yes.i have tried transaction ,and my database is created by the name ':memory:'.
now it takes about 5 minutes to insert 20 thousand record. it is really slow. by the way,how do i use 'pragma'? like sqlite_exec(handle,"PRAGMA cache_size = 4096",...)? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users