3 messages in com.mysql.lists.gui-toolsRe: lag after executing queries in Br...| From | Sent On | Attachments |
|---|---|---|
| Thanos Panousis | 05 Mar 2007 06:47 | |
| Rolando Edwards | 05 Mar 2007 08:35 | |
| Thanos Panousis | 05 Mar 2007 12:34 |
| Subject: | Re: lag after executing queries in Browser |
|---|---|
| From: | Rolando Edwards (redw...@swmx.com) |
| Date: | 03/05/2007 08:35:42 AM |
| List: | com.mysql.lists.gui-tools |
I have this problem thousands of times.
The problem is the way Query Browser executes queries. Each time you request a query to be executed, IT OPENS A NEW CONNECTION This is true whether you drop a table, add a stored procedure, anything.
Here is the big question : Are you accessing a MySQL database running locally, another machine running Windows, or another machine running Linux ???
IF you accessing MySQL running on another machine with Linux, is logging into Linux fast or slow ??? I ask this because network congestion or activity has a direct bearing on how fast each MySQL connection gets established from Query Browser.
Try rebooting Linux where MySQL is running. If that works, then configure Linux to authenticate as fast as possible going forward.
----- Original Message ----- From: "Thanos Panousis" <ptha...@gmail.com> To: gui-...@lists.mysql.com Sent: Monday, March 5, 2007 9:47:56 AM (GMT-0500) Auto-Detected Subject: lag after executing queries in Browser
Every time I execute even the most straightforward of queries, the whole browser hangs for 2-3 seconds and then submits the query to the server.
This makes the application a hell of lot less productive, and makes fast queries times take time.
I have the latest 1.2.10 version of the query browser in windows XP. I have noticed this issue does not exist in the linux version. What should I do?