Program crashes with DB - 12000 Tables

jahsen posted 3 years ago in General
Hello, I have a database with many tables ~12000,
When I try to open this DB (MySQL) Heidi crashes unhappy

Here is error report:

date/time : 2014-09-08, 14:33:42, 518ms
computer name : YJILKOV
user name : yjilkov <admin>
registered owner : Asen
operating system : Windows 7 x64 Service Pack 1 build 7601
system language : Bulgarian
system up time : 11 days 11 hours
program up time : 3 minutes 41 seconds
processors : 4x Intel(R) Core(TM) i5 CPU 650 @ 3.20GHz
physical memory : 3917/7989 MB (free/total)
free disk space : (C:) 17,38 GB
display mode : 1920x1080, 32 bit
process id : $15bc
allocated memory : 86,58 MB
largest free block : 8185,77 GB
executable : heidisql.exe
exec. date/time : 2014-09-08 14:29
version :
compiled with : Delphi XE5
madExcept version :
callstack crc : $6aa13b63, $eb0cad7c, $eb0cad7c
exception number : 1
exception class : EStackOverflow
exception message : Stack overflow.

main thread ($1a8):
7fefd30a KERNELBASE.dll InternalLcidToName
7fefd302 KERNELBASE.dll CompareStringW
77094ee6 kernel32.dll CompareStringW
00473a74 heidisql.exe System.SysUtils WideCompareText
009039f0 heidisql.exe SynHighlighterHashEntries 200 +4 TSynHashEntry.AddEntry
00903a71 heidisql.exe SynHighlighterHashEntries 207 +11 TSynHashEntry.AddEntry
ansgar posted 3 years ago
I can try to fix that here. This crash seems to be happen when adding the 12000 table names into SynEdit's internal list. I guess you can live with it when Heidi does not highlight all of these 12000 table names in the editor, but let's say the first 1000 tables only.
jahsen posted 3 years ago
Of course, i understand that this is not a usual problem but i like the program so much and i will be very glad if i could work with it with all my databases. smilesmilesmile
ansgar posted 3 years ago
I spent one hour to find the place where table names are being added to the highlighter, with no luck yet. Damn I was sure it was TSynSQLSyn.TableNames. Will keep looking.
jahsen posted 3 years ago
Thank you!!!
ansgar posted 3 years ago
Fixed in r4817. Highlighter does no longer try to highlight tables when there are more than 1000.
jahsen posted 3 years ago
YOU ARE THE BEST!!! I am gonna' try it out right away! :)
jahsen posted 3 years ago
It works smile
Guentiganz posted 2 years ago
Hi there,

I have the same probleme here.
900 tables and about 600 Triggers.
Is it possible to skip highlighting for triggers?
Is there any reason to highlight them?
Maybe you could higlight the first 1000 items, or may increase this number?
thank you
ansgar posted 1 year ago

The SynEdit guys fixed that slowness issue with many table names!

In my tests I simulated 50000 table names without a notifiable waiting time.

I merged the changes into HeidiSQL in r5111 so you can test yourself. I also removed the limitation to 1000 tables names now.

Guentiganz posted 1 year ago

Highlighting works fine. Thank you

But, Everytime I try to do autocompletion using CTRL + SPACE Heidi executes an show create table for each table and a show create trigger too. in my case there are about 1600 show creates beeign executed.

ansgar posted 1 year ago

That has nothing to do with highlighting, does it?

Well, if you're on a newer MySQL server, these SHOW CREATE queries should be fired as one big multi-statement with semicolons between each single one, are they?

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