BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Scrolling large datasets

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> JBuilder Databases
View previous topic :: View next topic  
Author Message
Zvonko
Guest
PostPosted: Wed Jun 07, 2006 8:12 am    Post subject: Scrolling large datasets Reply with quote


Hi!

I have a large dataset of about 20.000 records. Could you tell me the
best performance techniques to show this dataset in a table and scroll it.
In the same time I have to fetch some information from database everytime a
user change the selected row in a table and show this information in a bunch
of jLabels.

So basically I would like advice on your experience about the best
performance techinques (JTable or JdbTable or something else...perhaps third
party!?)

Thanks for your answers,
Zvonko
Back to top
John Moore (TeamB)
Guest
PostPosted: Fri Jun 09, 2006 1:02 am    Post subject: Re: Scrolling large datasets Reply with quote


Zvonko wrote:
Quote:
Hi!

I have a large dataset of about 20.000 records. Could you tell me the
best performance techniques to show this dataset in a table and scroll it.
In the same time I have to fetch some information from database everytime a
user change the selected row in a table and show this information in a bunch
of jLabels.

So basically I would like advice on your experience about the best
performance techinques (JTable or JdbTable or something else...perhaps third
party!?)

There are a number of issues here.. First what human can actually scroll
20,000 records and do it in a meaningful way.. within a reasonable
amount of time..

You might consider creating the ability to view ranges of data based on
specific criteria. In this way the user is only fetching dozens of
records and at the most a hundred..

The next issue is around the dbswing components and for that you need to
post your question in the dbswing section..

We just do the backend stuff here..<GGG>

John..




--
=============================================
TeamB are volunteer helpers. Please DO NOT REPLY VIA EMAIL!
Post all questions and replies to this newsgroup ONLY
For papers on DataExpress, Applets, JSP, and Web Development go to:
http://www.microps.com/mps/paperFAQ.html
====================================================
Back to top
Paul Nichols (TeamB)
Guest
PostPosted: Sat Jun 10, 2006 12:07 pm    Post subject: Re: Scrolling large datasets Reply with quote


Zvonko wrote:

Quote:
Hi!

I have a large dataset of about 20.000 records. Could you tell me the
best performance techniques to show this dataset in a table and scroll it.
In the same time I have to fetch some information from database everytime
a user change the selected row in a table and show this information in a
bunch of jLabels.

So basically I would like advice on your experience about the best
performance techinques (JTable or JdbTable or something else...perhaps
third party!?)

Thanks for your answers,
Zvonko

John is right about fetching the records and scrolling operations,
especially over a Network. However, this seems to me like a perfect
candidate for the newer RowSet model, IMHO.
Back to top
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> JBuilder Databases All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.