🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.jbuilder.database
Article #200

Re: Scrolling large datasets

#200
From: John Moore (TeamB)
Date: Thu, 08 Jun 2006 20:02
38 lines
2318 bytes
Zvonko wrote:
> 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
====================================================
Technical Details
Message-ID: <44888244@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news.glorb.com!news2.volia.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <448663bf$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 1073da,7741db0d120ee3af
X-Google-Attributes: gid1073da,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Thu, 08 Jun 2006 13:02:13 -0700
From: "John Moore (TeamB)" <jbm@microps.com>
User-Agent: Mozilla Thunderbird 1.0 (Macintosh/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.jbuilder.database
Subject: Re: Scrolling large datasets
References: <448663bf$1@newsgroups.borland.com>
In-Reply-To: <448663bf$1@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 207.137.13.178
Message-ID: <44888244@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1149796932 207.137.13.178 (8 Jun 2006 13:02:12 -0700)
Lines: 38
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news.glorb.com!news2.volia.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail