>  c.execute("INSERT INTO player VALUES 
> ('Player%d',%f,NULL)"%(i,random.random()))

>real    5m29.157s
>user    5m22.137s
>sys    0m5.457s

Not that it makes much of a difference since this is only for "testing" but 
using:

   c.execute('INSERT INTO player VALUES (?,?,NULL);', ('Player%d' % i, 
random.random()))

is 500% faster since you are using the same statement )prepared once) and only 
changing bindings rather than having to prepare 10000000 different statements.

TimeThis :  Command Line :  createPlayer.py
TimeThis :    Start Time :  Sun Aug 24 00:12:41 2014
TimeThis :      End Time :  Sun Aug 24 00:14:02 2014
TimeThis :  Elapsed Time :  00:01:20.296




_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to