long query with profile query

[expired user #5298]'s profile image [expired user #5298] posted 14 years ago in General Permalink
When i run a long query with the profile query option, the heidisql get still stuck. I use version 3607.

Great work in this field. I think that this feature us the only feature that i really missed in heidisql
smile
[expired user #5298]'s profile image [expired user #5298] posted 14 years ago Permalink
also after the query runs the heidisql does not reurn. I have to kill the editor
ansgar's profile image ansgar posted 14 years ago Permalink
Probably important to notice: If you start a long query, then start something else, let's say the user manager, or click a table or a database in the tree, this is of course a problem as the server is not able to run parallel queries in one connection. Queries are run in a separate Windows thread, but do not mix up - they are runing in the same connection thread currently. Just had the idea of opening a new connection for each user query execution, which would heal this problem. On the other side this would break usage of cached objects, and session based variables etc., so that's not a good idea.

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