Re: JDBC and Oracle

I don't think the customer exactly know what they want and what is realistic. I have the hundrets queries think from my boss. Do you can guess how much short queries which short results are possible from JDBC on a big Oracle DB on a fast Unix machine?
Yes, I am thinking on the precompiled PL/SQL procedures in the DB. It's new for me that I can write them also in Java...Do you have a advice where I can look for this? (I'm in the planning phase)
Do you know if a realtime generator for Oracle PL/SQL procedures exists, so that I generate them from Java in realtime.
Or is there at least some kind of non-realtime generator for PL/SQL, so i must not do the shitty PL/SQL coding...
Optimizing the Oracle DB is a difficult thing cause its a big company with a big DB. I guess optimizing their DB belongs to their system administrators. But I will discuss this with them if they wants much more speed.

Matthias

Somebody schrieb:

> Instead of using JDBC, I would suggest that you write stored procedures in
> the database, and call these procedures from your program.
>
> That way you can alleviate traffic and only receive the results needed
> instead of calling the database hundreds of times. (Are you sure you mean
> what you say? Hundreds of queries per second or do you mean hundreds of
> rows per second? If you mean what you say, you'ld better look into other
> performance enhancing techniques on the database administration side like
> caching, precompiling, clustering, load balancing, etc. Tune your queries
> as well.)
>
> You can write your stored procedures in PL/SQL or Java. These are then
> cached in the database.
>
> You might also look into using the OCI drivers instead of the thin drivers.
>
> Nicodemus Chan.
> (nicodemus_at_NOSPAMOKAYdavidaslan.com)
>
> "Matthias Kampmann" <matthias.kampmann_at_uni-bielefeld.de> wrote in message
> 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 Tue Oct 01 2002 - 12:39:13 CEST