Limit Displayed Rows vs Query Row Limit?

[GenDemo]

Hi All

Is there a performance difference between limiting your visualisation to say, 18 rows, vs. limiting the number of rows displayed in the data section (i.e. in the query) to 18.

[vtanhuat]

Hi,

I think that limiting the displayed rows (or limiting data with filters) will have effect to the actual executed sql. Limiting in visualisation is done on ui level. So based on that limiting rows is probably more efficient. Of course this depends how complicated your sql query is.

Br,
Vesa