Performance regression in phase four

OpenBEL / openbel-framework

An open platform for capturing, integrating, storing, and sharing biological knowledge in and across organizations.

http://openbel.org

Apache License 2.0

22 stars 7 forks source link

Performance regression in phase four #26

Open abargnesi opened 12 years ago

abargnesi commented 12 years ago

Inserting records into MySQL/Derby (and presumably Oracle) is very slow. This seems to be a regression issue, but it would also be nice to use batch inserts properly.

Possibly related to #25

JamesMcMahon commented 12 years ago

Our Desktops are now using a newer version of MySQL (5.5 vs 5.1 on some of the servers). The default database engine has been switched from MyISAM to InnoDB. I think this is to blame for a lot of the poor performance we are seeing here.

Tony tested this out and saw that when he switched his default database engine back to MyISAM that the KAM insert was significantly faster.