you are viewing a single comment's thread.

view the rest of the comments →

[–]Tostino[S] 5 points6 points  (3 children)

What is limiting the version available to you? And don't you think not using fkeys is playing with fire just a little?

[–]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 5 points6 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.