Timeout on Large mySQL Query
- by Bob Stewart
I have this query:
$theQuery = mysql_query("SELECT phrase, date from wordList WHERE group='nouns'");
while($getWords=mysql_fetch_array($theQuery)) {
echo "$getWords[phrase] created on $getWords[date]<br>";
}
The data table "wordList" contains 75,000 records in the group "nouns" and every time I load the code I am returned an error. Help!