Threaded queries and finding a new logo
| User, date | Message |
|---|---|
|
Written by ansgar
2 years ago Category: News 4029 posts since Fri, 07 Apr 06 |
User fired queries in a query tab are now processed in a separate thread, which makes the GUI responsive while you run a longer query. Many users asked for that in issue #1509, which is finally fixed now. However, there is one follow up issue, caused in one specific scenario - will be fixed soon. Please update to the latest build to check that out (Help > Check for updates). Second thing is I am searching for a new logo image, including an application icon in sizes of 16px, 32px and 48px. As a non-designer, I recently tried out some of my own ideas but in the end they all feel slightly wrong and ugly. If you have a good idea or even like to create a logo for HeidiSQL feel free to comment and attach files on issue #2332. The new logo should contain some green area - everything else is up to the creator. |
|
Written by Rvanlaak
2 years ago 23 posts since Sat, 25 Dec 10 |
Does the export window also use a separate thread? Often HeidiSQL crashes because tables of > 120 MB are exported through one of my SSH tunnels |
|
Written by ansgar
2 years ago 4029 posts since Fri, 07 Apr 06 |
No, because of thread complexity and performance overhead I only made user fired queries use there own thread. |
|
Written by Rvanlaak
2 years ago 23 posts since Sat, 25 Dec 10 |
Ok, and is there any chance that the export window also will use its own thread in the near future? 
|
|
Written by ansgar
2 years ago 4029 posts since Fri, 07 Apr 06 |
For what reason? You would not be able to do more than watch the window - which you can do now also as there are repaint's from time to time. |
|
Written by Rvanlaak
2 years ago 23 posts since Sat, 25 Dec 10 |
Am I right if I say that when the export window is a separate thread, you can work while the export is running? In my opinion it would be nice if the user gets more feedback whey big tables are exported. |
|
Written by ansgar
2 years ago 4029 posts since Fri, 07 Apr 06 |
You are still restricted to run one query at one time, as the server does not allow doing multiple parallel queries in one connection. You would get some "Commands out of sync" error if you would trigger any query. |
|
Written by 4ndy
2 years ago 4 posts since Mon, 08 Jun 09 |
Have you considered always opening a new connection besides the existing one after execution and closing/re-opening when query(thread) finishes? |
|
Written by ansgar
2 years ago 4029 posts since Fri, 07 Apr 06 |
Yes, of course I have considered parallel sessions. What is then again problematic is that any session-based stuff would be gone, e.g. some variable you have set before: SET @myvar:=123 If you query that variable in a later query: SELECT @myvar that would return nothing. There is also more affected session based stuff, like when you fire SELECT FOUND_ROWS() or SHOW ERRORS or the query profile which can be activated via checkbox. So, I'm afraid having parallel sessions would introduce more annoyance than it would heal currently. |
|
Written by kalvaro
2 years ago 457 posts since Thu, 29 Nov 07 |
Even worse: START TRANSACTION; |
|
Please login to leave a reply, or register at first. |