I use PostgreSQL a lot but these benchmarking results surprise me. MySQL is often much faster than PostgreSQL and SQLLite is several times faster than MySQL.
What matters to me is how fast they work with Python, or in particular Zope. I need to make my own benchmark of MySQL and PostgreSQL with Zope and all the various database adapters.
The reason I moved from MySQL to PostgreSQL was partly because PostgreSQL has more enterprise features and that my colleges use PostgreSQL. But I suspect that for many of my projects I never even use these features.
Then I also found this from a Zope mailing list:
>The speed comparisions with PostgreSQL are very much an apples vs. fish
>sort of thing: the pgsql server was not tuned at all, and does a whole
>lot more that was never tested, such as multi-user writer access.
- Challenge Osama with scimitar or sword
02 April 2004
- XHTML, HTML and CSS compressor
07 April 2004
- Related by Keyword:
- Fastest *local* cache backend possible for Django
04 August 2017
- How to do performance micro benchmarks in Python
24 June 2017
- How do log ALL PostgreSQL SQL happening
20 July 2015
- Benchmarking Autocompeter
12 April 2015
- Fastest database for Tornado
09 October 2013
- Related by Text:
- Why bother with MySQL...
09 October 2008
- Date formatting in python or in PostgreSQL
20 July 2004
- rfc822() vs. rfc1123_date()
16 August 2007
- Speed test between django_mongokit and postgresql_psycopg2
09 March 2010
- Loadtesting this site and compare with static Apache
15 October 2003