MySQL Forums
Forum List  »  Performance

MySQL performs very very slow
Posted by: David West
Date: February 15, 2005 03:39PM

I am currently testing MySQL in our organisation. I have populated the database with our organisations data (about 1Gb) and indexed the data.

Initial tests resulted in very fast performance. Our tests were done using easy complex queries (ie. a few tables using only inner joins).

When we tested MySQL with a harder complex query the results were somewhat disapointing. I am unable to present the query used due to confidentiality however the query contained a table and a derived table (the derived table contained two tables with an inner join). The table was left joined to the derived table.

MySQL took approx. 10sec to perform the query where SQL Server (another database we are testing) returned the result in less than 0.5sec.

The engine type was InnoDB since the database needs to be transactional.

Does anybody else experiance the same problems?

Options: ReplyQuote

Written By
MySQL performs very very slow
February 15, 2005 03:39PM
March 14, 2005 06:13AM
February 18, 2005 03:17PM
February 21, 2005 01:41AM
February 23, 2005 05:29PM
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.