Why does Heidi SQL Freeze whenever I run a query?

[expired user #5084]'s profile image [expired user #5084] posted 14 years ago in General Permalink
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
ansgar's profile image ansgar posted 14 years ago Permalink
HeidiSQL uses a single thread and does not yet take a separate thread for running queries, so that's very normal. See issue #1509.
[expired user #5015]'s profile image [expired user #5015] posted 14 years ago Permalink
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.