heidisql is slow on huge queries

[expired user #5298]'s profile image [expired user #5298] posted 13 years ago in General Permalink
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
[expired user #5821]'s profile image [expired user #5821] posted 13 years ago Permalink
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.