Hi Mark,
That URL at the end of my last email was obviously incorrect. The
correct URL is:
technet.oracle.com/tech/java/sqlj_jdbc/
Regards
Michael
Hi Mark,
Just a couple of notes.
1. Determine if the database is at fault using SQL*Net from a client machine
and submitting the same SQL statement that is causing you the performance
problems. Use utlbstat and utlestat if necessary to isolate and check
performance of the database itself.
2. Is the Java application (on the server machine) using the same driver as the
servlet that is on the NT machine?
3. Use the Type 2 OCI driver for servlets rather than the thin driver. The thin
driver is better suited for applets. The OCI JDBC driver has performance (and
functionality) improvements.
4. Ensure that your servlet is connecting once, say in the init() method rather
than everytime that the servlet requires data from the database (eg in the
service() method).
5. Ensure that you use parameterised JDBC calls rather than hardcoding the
value of SQL variables in select statements.
You can download the latest drivers from
technetinside.us.oracle.com/tech/java/sqlj_jdbc/
Regards
Michael
Mark Foley wrote:
> Hi All!
>
> We are experiencing very slow response times from an Oracle database when
> accessed from our servlets. However, from a Java application on the web
> server machine the response is much quicker. Has anybody noticed anything
> similar?
>
> We are using Oracle 8 on Solaris, IIS4/WebSphere2 on WinNT4 and Oracle thin
> JDBC drivers.
>
> As a comparison I configured two linux machines to use Apache/WebSphere and
> Postgresql, and found performance to be really snappy, (but then on a two
> machine network that shouldn't be a surprise I suppose).
>
> Apart from tuning the network, the database, or the queries, does anybody
> have any tips as to how they improve servlet-database performance?
>
> Thanks,
>
> Mark Foley
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
begin:vcard
n:Bamford;Michael
tel;cell:0410-601-301
tel;work:(02)9900-1367
x-mozilla-html:FALSE
url:www.oracle.com.au
org:Oracle Corporation;Business Solutions
version:2.1
email;internet:[EMAIL PROTECTED]
title:Senior Business Solutions Consultant
adr;quoted-printable:;;Level 7=0D=0A1 Pacific Hwy=0D=0A;North Sydney;NSW;2060;Australia
fn:Michael Bamford
end:vcard
begin:vcard
n:Bamford;Michael
tel;cell:0410-601-301
tel;work:(02)9900-1367
x-mozilla-html:FALSE
url:www.oracle.com.au
org:Oracle Corporation;Business Solutions
version:2.1
email;internet:[EMAIL PROTECTED]
title:Senior Business Solutions Consultant
adr;quoted-printable:;;Level 7=0D=0A1 Pacific Hwy=0D=0A;North Sydney;NSW;2060;Australia
fn:Michael Bamford
end:vcard
