MySQL Performance Improvement Needed Urgently
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
Subject
Views
Written By
Posted
MySQL Performance Improvement Needed Urgently
4147
April 01, 2005 02:06PM
2099
April 01, 2005 09:20PM
2605
April 02, 2005 05:54AM
1989
April 02, 2005 07:04AM
2188
April 02, 2005 07:22AM
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.