5 messages in com.mysql.lists.win32Re: Slow Performance on Remote MySQL ...
FromSent OnAttachments
Carl Horton22 Apr 2002 07:00 
Pete French22 Apr 2002 07:12 
Carl Horton22 Apr 2002 07:30 
Carl Horton22 Apr 2002 07:35 
Pete French22 Apr 2002 07:38 
Subject:Re: Slow Performance on Remote MySQL Server
From:Pete French (pfre@firstcallgroup.co.uk)
Date:04/22/2002 07:12:23 AM
List:com.mysql.lists.win32

Database Completion Time Local Access DB 50 seconds

MySQL Local 15 seconds (I no longer keep it local, only for testing)

MySQL 1 hop away 7 minutes

Thsi is an identical query right ? I suggest you turn on the slow query log and see if it is the actual query taking the time, or if its the creation of the connection itself which is causing the problem.

By local I assume you mean logging onto the machine 1 hop away and running a local copy of the command line app there ?

Without more info then its hard to suggets anything but query times should be identical, no matter what the connection method.

-pcf.