1

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

1 Answer 1

2

"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

3

You must log in to answer this question.