-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 liubin liu wrote: > Is it the ceiling of the SQLite3? If no, how to improve it? espically > improving the routine of writing.
Your testing is not testing what you think it is. The test times include string formatting and query parsing in addition to statement execution. What you should be doing is preparing your statements in advance and then using bound parameters (the sqlite3_bind_* family of functions). You should only be timing from the first bind call through sqlite3_finalize. Also use some sort of source code control. Having large chunks of commented out code makes it far more difficult to read through and understand what is going on. If you use source control you will always be able to refer back to older and deleted code, rather than complicating things with commented out code. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAksy/iUACgkQmOOfHg372QQyoQCg5MIt9df9T33KCoqsvKrnnTPF Ro0An0CcofQA0WeTDJiGuTJMtAjt8VCK =Huo9 -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users