topic Re: Which feature consumes more resources, Window function or Group by? in App Development

Which feature consumes more resources, Window function or Group by?

MeehyeOh — Wed, 24 Apr 2024 00:39:39 GMT

Hi,

I've been using it very well since the Window function was added.
I wonder if the window function or the group by consumes more resources.
And what functions perform faster when loading data?
I don't know the difference because my test data capacity is small.

Reply, Thanks!

Re: Which feature consumes more resources, Window function or Group by?

Pierrick — Fri, 26 Apr 2024 09:31:26 GMT

Hi !
At the moment, it seems to me the window function is a little slower and uses slightly more power than group by. The difference is noticeable with large volumes of data or repeated use.