> 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