Hey!
I think you have a database driver problem and not a servlet problem.
Are you using the same driver in both instances of your test?
Is the database on the same machine as the webserver for your test?
I probably shouldn't be replying because I have no experience with
Oracle. But you might get some clue from what I say.
For IBM DB2 UDB, there are two drivers one named "net" (Type ? driver),
and one named "app" (Type ? driver). I forgot the type numbers (?).
The net does not need any application installed on the client machine and
used primarily for browser (applet) access to the database. "net" is
slower (but hardly noticeable) than the "app" driver which accesses the
database on your network and requires that the client have a driver
on the local machine.
I would do a test like this. Given client machine connected to your network,
run a Java application on the client that uses each of the drivers for Oracle,
i.e., "net" and "app" or what ever Oracle names them. This might give you
a clue.
Also, you may access the archive:
http://archives.java.sun.com/archives/servlet-interest.html
I remember reading some postings about Oracle JDBC driver problems.
You may be able to get a clue from them.
Sorry about the off topic reply guys but I don't think servlets are the blame
on this one.
Danny Rubis
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
___________________________________________________________________________
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
