remote vs local v.slow - ODBC in the frame

[luigi mazzetti]

Running using the query analyser or Crystal reports against a Mysql DB locally is very snappy. However running against another machine is very very very slow.

To give you an idea just parsing my query takes a long time - very frustrating waiting for a minute for the Query analyser to tell me there is a synatx error in my query. this takes milliseconds on the local machine. Mysql.exe is quick when connecting to the remote machine - so it must be ODBC driver? I think the query analyser uses odbc to connect?

I've read here there are problems with prepare statements - but I don't have the technical knowledge to get into odbc api calls and also Crystal reports needs to use the odbc driver..

Whats up?

Using Win2000 server and tried on XP - same thing (4.1 mysql)