Add row_limit settings

Open aki77 opened this issue 5 years ago • 1 comments

I think this is useful in cases where the execution of a query doesn't time out, but the number of results is so large that it takes a long time to render.

I actually tested this with a simple query that returned 100,000 rows of results. What would normally take more than 20 seconds to render was reduced to less than 5 seconds.

#270

Nov 16 '20 20:11 aki77

@ankane

What do you think about this PR? I'm having trouble with occasional server failures due to queries being executed with too many results. Even though I have set the timeout to 10 seconds, it hasn't helped because the query is running so fast.

Apr 17 '21 05:04 aki77