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.
Well, that's exactly what we do.
We tell the user:
"Your query returns 123,456 records and in this JList you see the
first 40
and here you have an scrollbar, you may scroll down if you want, but
you'll see your cursor changing into a clock sometimes, while the client
brings in additional records. Wouldn't it be better for you to refine that
query?"
Al this is implicit in the GUI controls, of course.
Regards
Javier
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".
|
