On 31 May 2009, at 2:27pm, Jim Wilcoxson wrote: > g5:~ mac$ Python-2.6.1/python.exe dbsync.py > /Users/mac/Python-2.6.1/Lib/sqlite3/dbapi2.py:27: RuntimeWarning: > Python C API version mismatch for module _sqlite3: This Python has API > version 1013, module _sqlite3 has version 1012. > from _sqlite3 import * > For pragma synchronous= off Time: 1.97417807579 TPS: 1519.61975305 > For pragma synchronous= normal Time: 4.06918787956 TPS: 737.247846202 > For pragma synchronous= full Time: 4.78447008133 TPS: 627.028688445
Standard MacBookPro3,1 Core 2 Duo 2.4 GHz, OS 10.5.7, whatever hard disk Apple puts in them. Using SQLite version 3.4.0 (installed as part of the OS installation). SimonsMBP:Documents simon$ python --version Python 2.5.1 SimonsMBP:Documents simon$ python dbsynch.py For pragma synchronous= off Time: 2.70638608932 TPS: 1108.48929199 For pragma synchronous= normal Time: 4.9895169735 TPS: 601.260606174 For pragma synchronous= full Time: 6.40981006622 TPS: 468.032588954 So are Python 2.5.1 and SQLite 3.16.14 so much faster they more than make up for a faster Core 2 Duo machine ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users