Autarchy of the Private Cave

Tiny bits of bioinformatics, [web-]programming etc

    • Archives

    • Recent comments

    Archive for October 6th, 2011

    MyISAM vs InnoDB vs Postgres benchmark

    6th October 2011

    For some reason, I believed that MyISAM storage engine should be very fast – faster than InnoDB and Postgres. After all, MyISAM does not support transactions, has no logging, and is overall simpler than “true” storage engines/databases.

    I was surprised to find out that this isn’t true, at least for the specific (simple!) query I’m interested in:

    1. SELECT primary_id FROM tablename WHERE indexed_varchar = %s AND intcol1 < = %d AND intcol2 > %d

    Read the rest of this entry »

    Share

    Posted in Notepad | No Comments »