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

heidisql is slow on huge queries

User, date Message
Written by michaelgangMoney, Euro
3 years ago
Category: General
45 posts since Wed, 17 Nov 10
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
Written by csiqojerncjsa
3 years ago
12 posts since Sun, 10 Jul 11
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.