query limit issue with php and mysql (drupal 6)

Question

hi i was trying to do a query in drupal which selects every row in table, i was having an issue with the no of rows i was able to query for the query is working for 300row limit but if i increase it 400 it is going blank page.

$total_terms = 300;
$query = "SELECT N.nid ,N.tid FROM term_node N  ";
$query_result = db_query_range($query, $vid, 0, $total_terms);

Answer 1

You are probably timing out, or exceeding your memory limit. Check the Apache and PHP logs.

Answer 2

You might want to try the Batch API

It might be helpful to use the drupal_tweaks module; it allows you to set php execution time limit, as well as mysql default_wait limit.