Why does Heidi SQL Freeze whenever I run a query?

jason.fonseca posted 7 years ago in General

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?

ansgar posted 7 years ago
HeidiSQL uses a single thread and does not yet take a separate thread for running queries, so that's very normal. See issue #1509.
djdjohnson posted 7 years ago
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.