I am running MVC PHP application. After some times when database size increased gradually the application get slowed. Is there any specific reason of database size. How can I reduce the load time?
Optimize your query and your code, display and select only the fields that is needed, do not select *, also, you can use ajax to make the loading faster, since multiple users opening a php page simultaneously will slowdown the execution of your query