Ask Your Question
0

What is the problem with slow queries on PHP when dealing with large amounts of data in MySQL tables?

asked 2023-05-27 20:33:17 +0000

qstack gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
3

answered 2023-05-27 20:38:01 +0000

ladyg gravatar image

The problem with slow queries on PHP when dealing with large amounts of data in MySQL tables is that PHP has to wait for the MySQL server to process the query before it can proceed with the next step in the PHP script. If the query is slow, this can cause the PHP script to appear unresponsive to the user, and lead to longer load times and decreased performance. Additionally, slow queries can cause database locks, which can prevent other queries from being executed, leading to further delays and performance issues.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer


Question Tools

Stats

Asked: 2023-05-27 20:33:17 +0000

Seen: 10 times

Last updated: May 27 '23