Hi, thanks for quick reply. I'm more interested on the memory consumption and execution speed. I have a result of about 900000 rows and it looks like limiting the result like that also helps on the performance aspect. But I'm not sure about that. Is the whole result saved in memory then gets garbage collected, or the process is much smarter?
Do you run the query in the GUI or on command-line?
For even better performance, I recommend you to have a look at the following HOF function: