Mega Code Archive

 

Categories / Php / MySQL Database

 

Unbuffered Queries for Large Data Sets

<?php              mysql_connect("localhost", "php", "password");             mysql_select_db("phpdb");             $result = mysql_unbuffered_query("SELECT ID, Name FROM conferences;");             while ($row = mysql_fetch_assoc($result)) {                     extract($row, EXTR_PREFIX_ALL, "conf");                     print "$conf_Name\n";             }     ?>