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

Threaded queries and finding a new logo

User, date Message
ansgar Written by ansgar
4 years ago
Category: News
5098 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.
Rvanlaak Written by Rvanlaak
4 years ago
25 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
ansgar Written by ansgar
4 years ago
5098 posts since Fri, 07 Apr 06
No, because of thread complexity and performance overhead I only made user fired queries use there own thread.
Rvanlaak Written by Rvanlaak
4 years ago
25 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? smile
ansgar Written by ansgar
4 years ago
5098 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.
Rvanlaak Written by Rvanlaak
4 years ago
25 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.
ansgar Written by ansgar
4 years ago
5098 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.
4ndy Written by 4ndy
4 years ago
5 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?
ansgar Written by ansgar
4 years ago
5098 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.
kalvaro Written by kalvaro
4 years ago
605 posts since Thu, 29 Nov 07
Even worse:

START TRANSACTION;
...

 

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