On 31 May 2009, at 4:59pm, Simon Slavin wrote: > 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
I am, of course, an idiot. That was running from the command line. If I run it as a .pyc I get >>> import dbsynch For pragma synchronous= off Time: 2.69734382629 TPS: 1112.2052631 For pragma synchronous= normal Time: 4.79093813896 TPS: 626.182161611 For pragma synchronous= full Time: 6.31202697754 TPS: 475.283139739 SimonsMBP:Documents simon$ python dbsynch.pyc For pragma synchronous= off Time: 2.61415219307 TPS: 1147.59959575 For pragma synchronous= normal Time: 4.84184503555 TPS: 619.598516262 For pragma synchronous= full Time: 6.0191090107 TPS: 498.412637928 I don't see why the 'full' figures vary so much. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users