distal-attribute
distal-attribute
distal-attribute
distal-attribute

Why does Heidi SQL Freeze whenever I run a query?

User, date Message
Written by jason.fonsecaMoney, Euro
4 years ago
Category: General
7 posts since Fri, 06 Aug 10
Hi


I'm running Windows 7 on a p4 4500. I've got 4gb of ram. Whenever I remotely connect to a server for MYSQL and run a query, Heidi will freeze for the time it takes to run the query. Some of my queries can take 2 minutes + to run. I'd like to be able to use heidi to make more notes or write more queries while that query is running.

Does this happen to everyone or is it just me? is there some way to fix this?

thanks
Written by ansgar
4 years ago
5023 posts since Fri, 07 Apr 06
HeidiSQL uses a single thread and does not yet take a separate thread for running queries, so that's very normal. See issue #1509.
Written by djdjohnson
4 years ago
66 posts since Mon, 28 Jun 10
I posted some code in the thread for issue #1509 that I wrote to run queries in a separate thread. The same logic should work in HeidiSQL after being modified for the alternate library used for connecting to MySQL.
 

Please login to leave a reply, or register at first.