Hello Giuseppe, its pretty normal, cause maria engine have a log in the Data file who make insert, update and replace statements slower than Myisam, its secure th data enabling restore to any point in time to your database table. check the filsize in the data directory and you will understand better the FRM files both myisam and maria have the same size but the maria data file is bigger than the myisam one and also the myisam index file is bigger than the maria index file. if you need increase this relationchip tri to use myisam to insert fast and maria do insert reliable and fully recoverable (including deleted rows) table. i supose it can help you. best regards. Michel Souza On Tue, May 19, 2009 at 5:26 PM, Giuseppe Maxia <g.maxia@gmail.com> wrote:
Hi, I am doing some tests with Maria. Out of the box, without any tuning, the load of records (with multiple record INSERT statements) is 5 times slower than MyISAM, 4 times slower than InnoDB.
What can I do to make the loading faster?
Thanks
Giuseppe
-- The Data Charmer http://datacharmer.org/
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
-- Atenciosamente Michel Souza