Re: JDBC and Oracle
Date: Wed, 25 Sep 2002 22:15:44 GMT
Message-ID: <kAqk9.148$rw2.3034_at_news01.chello.no>
Oracles JDBC driver is pretty fast.
But what you may consider when you have that many querys, is to implement a
chaching mechanism for objects containg the results. I think Oracle have
that, or you could use something like poolman for connection pooling and
object chaching.
That may speed up things.
"Matthias Kampmann" <matthias.kampmann_at_uni-bielefeld.de> skrev i melding
news:3D91BA82.831E1E27_at_uni-bielefeld.de...
> Hello,
>
> I am on a project with Oracle and JDBC. A Servlet should process about
> serveral hundret SQL-Queries per sec with Oracle DB, with small data
> sets as return. Therefore the servlet should be very fast and stable.
> SQLJ is quite elegant, but I think its to lame for that cause it uses
> JDBC. Or is that bad rumour?
> By now I am planning to use JDBC type 1 or 4 and do Connecting Polling.
> At the moment I am getting the JDeveloper from Oracle. I know there are
> plenty of JDBC drivers.
>
> Is there anything faster than JDBC? (Only hoping)
> Has someone experiences with Oracle and Java-sql queries?
>
> Any suggestions?
>
> Thx in advance, Matthias
>
>
Received on Thu Sep 26 2002 - 00:15:44 CEST