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 category:
- How to create-react-app with Docker
17 November 2017
- Be very careful with your add_header in Nginx! You might make your site insecure
11 February 2018
- Linux tip: du --max-depth=1
27 September 2007
- set -ex - The most useful bash trick of the year
31 August 2014
- The best grep tool in the world; ripgrep
19 June 2018
- Related by keyword:
- Fastest way to uniqify a list in Python
14 August 2006
- Django ORM optimization story on selecting the least possible
22 February 2019
- How to do performance micro benchmarks in Python
24 June 2017
- When Docker is too slow, use your host
11 January 2018
- Benchmark compare Highlight.js vs. Prism
19 May 2020