Re: MySQL -- very LOUSY PERFORMANCE compared to MS SQL Server???
This is a discussion on Re: MySQL -- very LOUSY PERFORMANCE compared to MS SQL Server??? within the MySQL Database forums, part of the Database Forums category; "Ignoramus14359" <ignoramus14359@NOSPAM.14359.invalid> wrote in message news:PXkPf.12450$vb4.142@fe47.usenetserver.com... &...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-07-2006
|
|||
|
|||
Re: MySQL -- very LOUSY PERFORMANCE compared to MS SQL Server???
"Ignoramus14359" <ignoramus14359@NOSPAM.14359.invalid> wrote in message
news:PXkPf.12450$vb4.142@fe47.usenetserver.com... > MySQL 5.0: 41 minutes > SQL Server: 1 minute 50 seconds. > > I am not less than SHOCKED by this difference and would like to know > if there are any onbious tweaks that I could do. Turn off autocommit if you're using InnoDB. I'd guess that's the most likely performance expense, given the number of statements you mention. Also read the tips on these pages and try employing some of them: http://dev.mysql.com/doc/refman/5.0/...ert-speed.html http://dev.mysql.com/doc/refman/5.0/...db-tuning.html Regards, Bill K. 
|
Linear Mode
