MySQL Forums
Forum List  »  PHP

Re: SELECT stopping PHP script execution
Posted by: Phillip Ward
Date: September 22, 2014 07:09AM

Does your PHP code actually crash or does it just appear to "hang"?
How many rows are in this particular table?
Of those rows, how many are you expecting to retrieve?
Are there any long-running queries [still] running inside MySQL? (Turn on the Slow log, if you haven't already).

Without a "Where" clause to filter them down, you're going to get every single row in the table, which might take quite a while, depending on how many there are!

Regards,
Phill W.

Options: ReplyQuote


Subject
Written By
Posted
Re: SELECT stopping PHP script execution
September 22, 2014 07:09AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.