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

Vlisidis%20Akis's gravatar image

Vlisidis Akis
accept rate: 5%

Hi Vlisidis,

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.


answered 06 Sep '12, 04:38

Yalim%20K.%20Gerger's gravatar image

Yalim K. Gerger ♦♦
accept rate: 20%

edited 06 Sep '12, 04:38

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 06 Sep '12, 03:36

Seen: 1,746 times

Last updated: 06 Sep '12, 04:38

© Copyright Gerger 2017