Hello Sylvain,
The most effective way is to set up oracle connection manager in your
web server. Oracle provides you this facility and detailed
documentation.
And if you are still not satisfied, make the connection as dispatched
instead of dedicated(I guess this is what you are using).
And if you are still not satisfied, the final way is to install the
ORACLE and web server in the same box. Sometimes, the bottleneck might
be network especially if you are using VPN.
Friday, August 25, 2000, 4:26:50 AM, you wrote:
SR> This is slightly off topic, but as it concerns jsp/servlet developpment, I
SR> may ask it anyway.
SR> We have developped a small search engine, which worked just fine on a linux
SR> box running mysql as db engine. One of our client plans to serve it himself,
SR> on an UX server, with oracle. We do have to port the application, but we
SR> experience some problems.
SR> We are using the jdbc thin driver, and oracle server is used by nobody but
SR> this application. Sometimes establishing the connection takes 1 or 2
SR> seconds, and sometimes nearly 1 minute. I insist, the oracle server does
SR> serve only this database, and has no other function. What should I do to
SR> improve this ?
SR> Best regards
SR> sylvain
SR> ______________________________________________
SR> Sylvain Roche
SR> Responsable d�veloppement
SR> Add-Online
SR> www.add-online.fr
SR> 80 rue d'Alsace
SR> 69100 VILLEURBANNE
SR> France
SR> tel : +33 437431260
SR> fax: +33 437431269
SR> ===========================================================================
SR> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
SR> Some relevant FAQs on JSP/Servlets can be found at:
SR> http://java.sun.com/products/jsp/faq.html
SR> http://www.esperanto.org.nz/jsp/jspfaq.html
SR> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
SR> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
--
Best regards,
java_jason mailto:[EMAIL PROTECTED]
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
