Re: lag after executing queries in Browser

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" <[email protected]>
To: [email protected]
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?


-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]