I have 2 machines each with an instance of MySQL 5.0.45 for Windows.
The machines are :
1. Desktop AMD Athlon XP 1800+, 1024 Gb DDRAM, HDD Seageate SATA II 7200 rpm *mb buffer
2. Laptop Dell Insprion 6400 Intel Core 2 Duo , 1024 DDRAM 667, HDD 120 Gb 5400 rpm.
Both have installed Windows Xp SP2 + Avast Home v 4.7 Antivirus.
Both MySQL instances have a copy of the same database ( same tables, number of rows, indexes etc ) and are configured identicaly ( they have the same my.ini file ).
The problem comes when i run a stored procedure that does some calculations on the database.
On system 1 it runs in 11 seconds, but in system 2 it runs in 3 minutes and 40 seconds.
What can i do ? What should i look at ? ( I am a developer not a dba, all the configurations to MySQL have been done from the wizard like installer.)