Article View: borland.public.jbuilder.database
Article #365Re: speeding up HSQL database
From: Gillmer J. Derge [TeamB]
Date: Mon, 13 Nov 2006 19:40
Date: Mon, 13 Nov 2006 19:40
25 lines
1920 bytes
1920 bytes
Oliver wrote:
> @SuppressWarnings
> ({"ReturnOfNull", "LoopStatementThatDoesntLoop"})
Does this actually work? I haven't been able to get JBuilder to honor
@SuppressWarnings annotations. I also haven't found a good list of
accepted values anywhere.
> { rs.absolute(rowIndex + 1);
My guess is that the slowness is related to this. My understanding is
that some (most?) drivers still scroll through the entire result set
when the absolute method is called. So, let's say rowIndex is 100.
Then you're reading through 100 rows of data before you get to the one
you want.
If you can alter your query so the query only returns the desired row,
that might help.
It also looks like you could trim down your result set quite a bit.
You're doing a "SELECT *" but you're only using one column (columnIndex)
in your code. A more streamlined query might be faster.
--
Gillmer J. Derge [TeamB]
Technical Details
Message-ID:
<4558ca40$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<455890fe$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 1073da,70ab5adc74a60808 X-Google-Attributes: gid1073da,public X-Google-Language: ENGLISH,ASCII-7-bit Date: Mon, 13 Nov 2006 14:40:48 -0500 From: "Gillmer J. Derge [TeamB]" <spam@gillmerderge.com> User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: borland.public.jbuilder.database Subject: Re: speeding up HSQL database References: <455890fe$1@newsgroups.borland.com> In-Reply-To: <455890fe$1@newsgroups.borland.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 24.149.56.198 Message-ID: <4558ca40$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1163446848 24.149.56.198 (13 Nov 2006 11:40:48 -0700) Lines: 25 Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail