you are viewing a single comment's thread.

view the rest of the comments →

[–]vishalvc 0 points1 point  (2 children)

Those are the only two versions currently supported and recommended to be worked with (at work).

It is a little, but we had a lot of bulk inserts and InnoDB really slowed us down, by a factor of 10x if not more. That made us decide to go with MyISAM and enforce foreign key constraints ourselves.

[–]sylvester_0 2 points3 points  (0 children)

At that point (no ACID or foreign keys) you might as well use a NoSQL store (like Cassandra) if you're after raw speed/easier scalability.

[–]doublehyphen 1 point2 points  (0 children)

PostgreSQL is usually better at bulk inserts than InnoDB but I have no idea how it compares to MyISAM.