Re: Oracle 8i and Java too slow

From: Jerzy Tomasik <tomasik_at_datapacket.net>
Date: Tue, 12 Jun 2001 21:28:10 -0700
Message-ID: <9g6q6s$jj5$1@news.chatlink.com>

Assuming you have decent hardware, these are the most common problems:

The JDBC driver is quite large (by now it's about 1 MB). Every time you run the applet it is downloaded. Java WebStart is one way to avoid that problem.
The most common performance problem I've seen is with fetching rows one-at-a-time. Look up Statement.setFetchSize() in JDBC documentation.

hth
Jerzy

"John" <makh0004_at_algonquincollege.com> wrote in message news:pxdV6.6094$nY4.1152942_at_news20.bellglobal.com...
> Hi, I am not very familiar with both but if someone could at least to
point
> in right direction or sourses.
> I am using Oracle 8i server and Java GUI to interact with db. The problem
is
> it is taking forever, waiting until applet is loaded, then query to
> execute... Is there way to improve it.
> Thanks.
>
>
Received on Tue Jun 12 2001 - 23:28:10 CDT