Load On Demand...

[Hakan Ç.]

Hi,
We are developing windows application with vb.net runs on oracle database.We
have a server/client structure and we are using remoting technology.As you
know a satisfied customer will be no more customer :) So our customer doesn't
satisfy and wants to see all products (30,000) at one click on a grid on
client side :) On Server side there is a function that executes query, fills
it in a dataset and client get it by remoting.Of course it takes long
time.Are there any technology to load rows on demand on the grid like Oracle
Forms.I am not very hopefull but maybe there is a way :) Is it utopia? For
example getting rows as needed when user scroll down on grid....

[Patrice]

Something like "paginating".

You could also ask him what he would do once all those 30000 records
displayed. If he watnts then to be able to filter those records, you could
ask him if starting with filtering would fit. In this case it could be
filtered before fetching all.

The last resort would be to load the first few records and to fetch the rest
as a background task (if really usefull)....

Good luck.
--

"Hakan Ç." <Hakan [e-mail]> a écrit dans le message de
news:6B**********************************@microsof t.com...

Hi,
We are developing windows application with vb.net runs on oracle database.We have a server/client structure and we are using remoting technology.As you
know a satisfied customer will be no more customer :) So our customer doesn't satisfy and wants to see all products (30,000) at one click on a grid on
client side :) On Server side there is a function that executes query, fills it in a dataset and client get it by remoting.Of course it takes long
time.Are there any technology to load rows on demand on the grid like Oracle Forms.I am not very hopefull but maybe there is a way :) Is it utopia? For
example getting rows as needed when user scroll down on grid....

[Hakan Cicek]

Thanx Patrice.
But there is no filtering for records.Normally answer is quite simple
"Result of a high record count it takes long time." But the old application
which customer is using developed on delphi by antoher company and its
product list runs very fast :(

"Patrice" wrote:

Something like "paginating".

You could also ask him what he would do once all those 30000 records
displayed. If he watnts then to be able to filter those records, you could
ask him if starting with filtering would fit. In this case it could be
filtered before fetching all.

The last resort would be to load the first few records and to fetch the rest
as a background task (if really usefull)....

Good luck.
--

"Hakan Ç." <Hakan [e-mail]> a écrit dans le message de
news:6B**********************************@microsof t.com...

Hi,
We are developing windows application with vb.net runs on oracle

database.We

have a server/client structure and we are using remoting technology.As you
know a satisfied customer will be no more customer :) So our customer

doesn't

satisfy and wants to see all products (30,000) at one click on a grid on
client side :) On Server side there is a function that executes query,

fills

it in a dataset and client get it by remoting.Of course it takes long
time.Are there any technology to load rows on demand on the grid like

Oracle

Forms.I am not very hopefull but maybe there is a way :) Is it utopia? For
example getting rows as needed when user scroll down on grid....