Digging into the formspider schema, I noticed that for every datasource there is a dsi_<datasource_oid> table create, containing actual data rows. I assumed that every time the datasource is queried the corresponding table is filled with the queried data. Is this true?
I am affraid that for large datasets this approach will have a huge performance & storage penalty.
asked 06 Sep '12, 03:36
Excellent question. In an application (I am assuming an OLTP application), you hardly deal with large datasets. Each grid will show 10,20,50 rows max at any point in time, even though the result of a query may contain many more rows. You never display 1 million rows at the same time. To limit the number of rows displayed, the Grid component should implement paging. This way, the datasource will only contain the rows that are in the current page.
So, no this never ever becomes a problem.