Scott Downey wrote:
> MyISAM tables were faster for us than ms sqlserver.
> On my PC using innodb tables it will beat against the hard drive when updating thousands of records
> at a time, where the Myisam tables (memory?) run 40% faster than ms sql server. Regular old select
> queries seem the same to me.
Generally, such differences are due to (insufficient or nonexistant) server tuning.
InnoDB is just happier (=faster) with more memory assigned to its buffer pool.
Regards, Arjen.
--
Arjen Lentz, Exec.Director @ Open Query (http://openquery.com)
Remote expertise & maintenance for MySQL/MariaDB server environments.
Follow us at
http://openquery.com/blog/ &
http://twitter.com/openquery
Edited 1 time(s). Last edit at 02/23/2005 06:32PM by Arjen Lentz.