MySQL Forums
Forum List  »  Performance

remote vs local v.slow - ODBC in the frame
Posted by: luigi mazzetti
Date: December 08, 2004 08:05PM

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)

Options: ReplyQuote

Written By
remote vs local v.slow - ODBC in the frame
December 08, 2004 08:05PM

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.