heidisql is slow on huge queries
| User, date | Message |
|---|---|
|
Written by michaelgang
2 years ago Category: General 44 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
2 years ago 9 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. |