MySQL Forums
Forum List  »  Performance

MySQL Performance Improvement Needed Urgently
Posted by: Tom Barrand
Date: April 01, 2005 02:06PM

Hi,

I am using MySQL 4.1 on Linux (IBM Open Power Server).

I have a Java based application that runs in Tomcat in a Windows environment using SQL Server. As part of a customer project I have got the application to work on Tomcat on Linux with MySQL.

Both databases have a large amount of data in some of the tables, e.g. 500,000+ records in some of the tables. Some of the tables have indexes on them.

There is a specifc part of the application that is slow when running against MySQL (10 seconds to write a record to a table with 500,000+ records in it.) The same bit of functionality running against SQL Server is instance, e.g. 2 secomds max.

I am presuming that some tweaks need to be made to MySQL so that it is optimised to handle this large amount of data.

Any ideas on what chances I could make to improve this?

Thanks for your help

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Performance Improvement Needed Urgently
3873
April 01, 2005 02:06PM


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.