0

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?

Ahmed Ashour
  • 5,179
  • 10
  • 35
  • 56
Mallikarjun
  • 13
  • 1
  • 5
  • u can index tables it will help to speed up little bit. Check the link below for indexing https://dev.mysql.com/doc/refman/5.7/en/mysql-indexes.html – Alex George Puthenpurackal May 08 '17 at 06:37
  • explain your queries with the EXPLAIN keyword. This will help you to understand where the query is taking time to complete the execution. Refer this link for more details.https://dev.mysql.com/doc/refman/5.7/en/explain.html – Sk_ May 08 '17 at 07:14
  • indexing table helped me little – Mallikarjun May 08 '17 at 12:41

1 Answers1

0

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

apelidoko
  • 782
  • 1
  • 7
  • 23