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:
- When Docker is too slow, use your host
11 January 2018
- Unzip benchmark on AWS EC2 c3.large vs c4.large
29 November 2017
- 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
- Related by Text:
- Be very careful with your add_header in Nginx! You might make your site insecure
11 February 2018
- jQuery and Highslide JS
08 January 2008
- I'm back! Peterbe.com has been renewed
05 June 2005
- Anti-McCain propaganda videos
12 August 2008
- I'm Prolog
01 May 2007