One interesting note is we have a server running on the remote end and we did a test and tried to access the remote end from the server location and there was no issue. What I am wondering now is if there are configuration settings slowing the connection down on one server but not the other.
Kurt Duncan > -----Original Message----- > From: Duncan, Kurt (MCUSA) [mailto:k...@medconnectusa.com] > Sent: Thursday, April 09, 2009 12:28 PM > To: mysql@lists.mysql.com > Subject: S L O W query over internet > > We are running a remote service and have an application that queries a > mysql database over the public internet. The ping test shows <60ms but > the queries take 40 seconds to 2 minutes to run at times. When we run > the same query using a local machine with <2ms it runs fast. I have > searched the internet and found several postings that this is normal > but I can't believe anyone would wait this long... does anyone have any > ideas or can you point me in the right direction? > > Kurt Duncan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org