MySQL Forums
Forum List  »  Performance

Re: Benchmark mySQL 5 and SQL Server 2000 - horrific!
Posted by: Arjen Lentz
Date: February 23, 2005 06:32PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
13267
February 15, 2005 03:39PM
Re: Benchmark mySQL 5 and SQL Server 2000 - horrific!
3523
February 23, 2005 06:32PM
3785
March 14, 2005 06:13AM
3610
February 18, 2005 03:17PM
3280
February 21, 2005 01:41AM
3071
February 23, 2005 05:29PM
3153
February 23, 2005 06:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.