Article View: borland.public.jbuilder.database
Article #200Re: Scrolling large datasets
From: John Moore (TeamB)
Date: Thu, 08 Jun 2006 20:02
Date: Thu, 08 Jun 2006 20:02
38 lines
2318 bytes
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-mailReferences:
<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