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:
- How I performance test PostgreSQL locally on macOS 10 December 2018
- The ideal number of workers in Jest 08 October 2018
- Best EXPLAIN ANALYZE benchmark script 19 April 2018
- When Docker is too slow, use your host 11 January 2018
- Unzip benchmark on AWS EC2 c3.large vs c4.large 29 November 2017
- Related by Text:
- 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
- Ever wondered how much $87 Billion is? 04 November 2003
- Guake, not Yakuake or Yeahconsole 23 January 2010