long query with profile query
| User, date | Message |
|---|---|
|
Written by michaelgang
2 years ago Category: General 44 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 
|
|
Written by michaelgang
2 years ago 44 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
2 years ago 3960 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. |