aggregations, table view and list view

Classic Servoy
1

I have a database with about 5000 users and something like 10 - 10.000 rows attached to that user via a relationship.

The related rows have 3 aggragations (1 count and 2 sums). Aggregating the values takes quite some time. I realise this so that’s not the issue.

What I found out, and I don’t understand why that is, is that showing the aggregations in a list view shows/builds the screen much faster than showing them in a table view…

Can somebody explain this?

2

huh?
It should be just the other way around.
The listview will be much slower. The table view starts to display much faster then listview and then fills in the aggregation values. A list view will wait until all the aggregation values are loaded and the display itself.

3

You are correct Johan. But because the list view shows up as a completed page I experienced it to be faster.

Thanx for the expanation.