Hey Javier,
If your client filters on a table that returns 100,000+ records then
something is wrong with either the user or the interface or possibly both.
You should inform them the filtering has to be more specific and return them
say the first 500 rows. There is no way an user will ever scroll down
through such a list unless they do not know what they have to do or how to
formulate what they need to do.
I suspect there is an ordering in your list which you could use to requiry
against the database. Maybe you could use this ordering to produce a new
form a list interaction that visually describes the dispersion of the data
and then allowing the user to zero on in on some area. But no matter what,
the scrolling through of 100,000 records even with your page number
mechanism, is still like an lost user walking in a forest.
kind regards,
William Louth
> -----Original Message-----
> From: Javier Borrajo [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, April 27, 2000 10:55 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Paging large database result sets
>
> Sincerely, I cannot see any reason for returning at least 100,000 rows to
> an
> user in whatever list component you may wish. <snip>
>
> Hey, this thread was about how to *not* having to transfer more than 40 or
> so
> records to the client, even if the query she/he performs is such that
> 100.000+
> records fit.
>
> You may want to review past messages to see the rationale, tricks,
> strategies, etc.
>
> Regards
>
> Javier
>
***********************************************************************
Bear Stearns is not responsible for any recommendation, solicitation,
offer or agreement or any information about any transaction, customer
account or account activity contained in this communication.
***********************************************************************
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
