Rows retrieving

[santosh2natal]

How can we retrieve huge number of rows (e.g. more than a million) in a datawindow simultanesously while viewing the rows retireved in the datawindow. (Not using "retireve as needed")?

 

[royjimenez]

I am not sure what u are trying to do, 'cause it's a bad idea
to perform a sql to retrieve too many rows. I think u should keep your data retrieved as short as u can.
Think if u have 100 users trying to execute your sql.

Regards.


The life is too short to cry and long enough to try it... God bless us.

 

[santosh2natal]

I meant, if there are a million of rows rquired to be retrieved i.e. if it is the requirement; then what we do usually is, we scroll down the datawindow till the elevetor of the scroll bar reaches to the bottom. But it starts going up again as the rows are being retrieved. Beacuse of this we have to wait or go on scrolling the datawindow till all the rows are retrieved. Instead doing this
How can we retrieve all these rows simultanesously while viewing the rows retireved in the datawindow. (Not using "retireve as needed")?