rs.next() very slow

Article View: borland.public.jbuilder.java.language

Article #7553

Back to borland.public.jbuilder.java.language Previous Next

#7553

From: J�rgen M�ller
Date: Wed, 06 Jun 2001 13:10

17 lines
1212 bytes

Hi all,

I use a ResultSet to get some data from an oracle-lite db.
The execution of the query needs only some milli-secs,
but when the rs.next() command is executed it takes
more than 30s, even if only one record will be returned.

The resultset has 20 fields, but this can't slow down the
performance in that way.

How can I improve performance??

Regards

J�rgen
Stuttgart
Germany

Technical Details

Message-ID: <3b1e2abc$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: f74b3,e827ba360c0bcffc,start
X-Google-Attributes: gidf74b3,public
X-Google-ArrivalTime: 2001-06-06 06:18:12 PST
From: "J�rgen M�ller" <juemu@web.de>
Newsgroups: borland.public.jbuilder.java.language
Subject: rs.next() very slow
Date: Wed, 6 Jun 2001 15:10:19 +0200
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 212.107.166.90
Message-ID: <3b1e2abc$1_2@dnews>
X-Trace: dnews 991832764 212.107.166.90 (6 Jun 2001 06:06:04 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews