PHP/MySQL Database/mysql unbuffered query
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";
}
?>