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

long query with profile query

User, date Message
Written by michaelgangMoney, Euro
3 years ago
Category: General
45 posts since Wed, 17 Nov 10
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
Written by michaelgangMoney, Euro
3 years ago
45 posts since Wed, 17 Nov 10
also after the query runs the heidisql does not reurn. I have to kill the editor
Written by ansgar
3 years ago
4940 posts since Fri, 07 Apr 06
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.