Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have built a web app that was performing very fast, until users from a third coutry (the majority) started using the application. Now its very slow.

I see from the logs that I keep getting ORA-12170: TNS:Connect timeout occurred when the usage is at the peak. How can I solve this?

Then what setup of apache would help speed up stuff? Load balancing, multiple instances?

Am running it on RHEL4

share|improve this question
add comment

1 Answer

"Connect timeout". A web app should generally have a connection pool permanently connected to the database. Setting up a database connection (and killing it at the end) is pretty expensive so it is not something you should be doing for each user.

Suggest you look at Database Resident Connection Pooling in 11g

share|improve this answer
    
the database is on a different machine, so the connection pooling you are talking abuot is to be implemented there or at the client? –  Ngetha Nov 5 '09 at 6:09
    
There are changes at both the database and client end. Details in a white paper oracle.com/technology/tech/php/pdf/php-scalability-ha-twp.pdf and you would probably get more detailed help at Oracle's PHP forum forums.oracle.com/forums/forum.jspa?forumID=178&start=0 –  Gary Nov 5 '09 at 22:02
    
thank you man!!!!!!!!!!!!!!! –  Ngetha Nov 6 '09 at 9:55
    
+1 for both question and answer. –  DCookie Nov 9 '09 at 19:21
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.