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

heidisql is slow on huge queries

michaelgang posted 3 years ago in General
I have a query with one million chars, and when i paste it to heidisql, the editor gets really slow.
The query is select * from X WHERE ID IN
(id1....id10000)
Notepad++ with sql syntax highlighting is much better. I am sure that it could be argued that the editor is not designed for such a query, but maybe there is a small bottleneck which can be resolved.
I am using revision 3918
csiqojerncjsa posted 3 years ago
You should consider rewriting your query using a JOIN expression. IN is considered to be slow. And 1000 values is quite too much.

Cheers, Robert

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