|
|
Posted by John Clarke on 10/25/06 03:57
Hi,
Am currently using a MySql database on my web server that I access using the
Php MySql commands. The performance is great.
As this database starts its life as a Foxpro one, I have tried to access the
original data using ODBC and the VFP driver.
In essence this works quite well until I request a complex procedure and
then it all falls apart.
The same procedure that talkes MySql 1 second to complete, times out at 60
seconds with only partial data returned using ODBC/VFP. During this time the
CPU maxes out to 100% utilisation. When using MySql it gets up to about 3%
for the whole 1 second.
The databases are the same size, are on the same WinXp server (as MySql
Server, Apache Server and Php) and the same Php code is used, albeit
slightly changed for the differences between MySql and ODBC.
Can anyone suggest to me why ODBC/VFP is horribly slow while MySql is a
rocket?
Thanks in hope.
Regards,
John Clarke
Navigation:
[Reply to this message]
|