long query with profile query

michaelgang posted 7 years ago in General
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
michaelgang posted 7 years ago
also after the query runs the heidisql does not reurn. I have to kill the editor
ansgar posted 7 years ago
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.