LIMIT rows as default setting value?
Have tried to find if there are any global settings for this, without success. Are there?
Missing this parameter is a show stopper. The risk of starting queries without the LIMIT parameter is to big.
Otherwise it looks very good.
Tried 1000 with max 1000 (step , maximum) and tried again. Still working and 12 GB of memory used.
If I extend the select with LIMIT 1000 - no problem an instant respons.
Must say that squirrels easy to change this parameter is very useful. (Input field in the query area)
And, must be one of the easiest things to implement.
But, anyhow, thanks for the answer. Good to know that there was no obvious settingalthough also a pity.
Please login to leave a reply, or register at first.