RE: S L O W query over internet

2009-04-10 Thread Duncan, Kurt (MCUSA)
. 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

S L O W query over internet

2009-04-09 Thread Duncan, Kurt (MCUSA)
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

W2008 Server Issues?

2009-03-16 Thread Duncan, Kurt (MCUSA)
1. Any issues running MySQL Ver. X on Windows 2008 Server? 2. Running a query to list all records of about 2600 records is very slow and gets an error of Extremely High Work Load, Each record does contain 1 LONGBLOB containing small voice recording. We are using the SQL Query Browser

Slow connection over VPN

2009-02-16 Thread Duncan, Kurt (MCUSA)
We have an application using mysql. When we run it locally there are no issues. If we try and connect to a remote database machine over VPN it works but takes a VERY long time to get anything done. We are using the exact same database. All other programs using the same VPN run fine and the