-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 06/01/2011 12:25 AM, Alessandro Marzocchi wrote: > The only thing that this program does > is creating a database, making a table where a pair of integer maps > 8192-bytes blobs and writing 100k rows in it. Any suggestions of what > I could be doing wrong?
A major difference I see is that you are storing strings in the Python version but blobs in the C version. Additionally the contents are different between the two being all '0' for the C while '01234567' for the Python. To make them identical use buffer() around the Python string which will then cause it to be treated as blob at the SQLite level. Another difference is that your timing does not include program startup for Python but does for C. Finally the databases have different file names. I'll bet that virus scanners and backup software are interfering to some degree during startup and operation. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk3l7rAACgkQmOOfHg372QS29gCfQ6hWfdEojNbnAb1knuxIWtUO NkEAnRzR0gQvz3W3caCUrEsBUuOyt6iD =S7lS -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users