Multiple Server Problems

[Aia]

Hello Everyone,
I currently have two different computer systems. One I will refer to as dev for Development and one and prod for production.
Both systems are running the same verson of MYSQL (5.0.51b) and MYSQL connector/net (5.0.9.0). I do not know the specifics of the hard drives in terms of performance.
The dev system is a single core machine running at 2.4GHZ with 1 gig of ram. The hd is a 30 gig that is fairly full.
The prod system is a intel dual core running at 2.4GHZ with 2 gigs of ram. It has a raid 1 array with 2 250 gig sata drives. The hd is fairly empty.

The main problem I am having is that the two systems do not have the same performance for inserts into the database. While neither has truely acceptable performance, at least the dev is within the performance range that I have been given.
The dev computer is able to manage about 1280 inserts in a minute. The production takes 2 minutes, and if replication is on then over 4 minutes. For a simple test I had the prod service connect to the dev database and the amount of time taken was under a minute.

I have not been able to locate any difference between the two different systems that would result in the production machine having worse performance then the older developmental machine.

A thread that is connected to this problem is located here: http://www.vbdotnetforums.com/showthread.php?t=27753. This was back when I thought the problem was my code and not something else.

I dont know if this will be related but the following article was used heavily during the set of the replication. http://dev.mysql.com/tech-resources/articles/advanced-mysql-replication.html

Aia

 

[Aia]

Hello Everyone,
I decided to test something out. I uninstalled the database completely including removing all the data that was present. I then ran a script that created empty tables, and inserted only required information for the test that I run.
My past tests had the following results:
With replication - 4 minutes.
Without replication - 2 minutes.
Fresh without replication - 1.5 minutes (150 seconds).

The system should be completing the test un under 1 minute.
I know this becuase the developmental computer which is older and less powerful is capable of doing it, and that is with the replication.
I am at a loss of why this is happening. I have been working on the problem for about 2 weeks now with no solution, only slightly improved results that will not fulfill the requirements.
If you need anymore information then what I have posted, please ask.
Aia