Thanks a lot! That may be the problem: my db file is corrupted. Below is the *PRAGMA integrity_check* result. It didn't return OK. <http://sqlite.1065341.n5.nabble.com/file/t8403/integrity_check.jpg>
I think it's because I set PRAGMA synchronous=off in Python code to enhance insert speed. Does that mean this db file can not be used anymore? Or is there any way I can fix it? -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users