How to increase performance and handle large number of connections
We are developing a web application, in which around 500 users may connect to the system at the same time. We have very little knowledge about the issues that might come up. Our application is running in php and connects to an Oracle server installed on a linux machine. Is there some solution which will help us handle these 500 simultaneous users? Where should we tune the system, should we write something in the php code to do this, or should we tune some parameters of the oracle server to do this or should we do something to the linux server on which oracle is running or can we do this at all the three places. This application is very crucial and we would like to do all that we can to tune the system. Kindly advice us as to what all can be done for this.