> On 15 June 2010 09:31, AI Rumman wrote: > How to return large resutlset (almost 2 millions record) in php? > > Presumably this is so people can download results rather than display > them in a browser? > > Here's a basic a raw version of what you can do: > > $db = pg_connect($connection_string); > > $results = pg_query($db, $query); > > while ($result = pg_fetch_array($results) > { > echo implode("|", $result) . "\n"; //typo before > } > > pg_close($db); > > Obviously that wouldn't do by itself, but it's quite simple to loop over > a result set. > > Regards > > Thom >
If that's the case surely you'd use some SQL to merge the data into one long string and return it in a single record. Looping over two million results is going to take a while, not to mention quite a bit of memory. v.
I don't understand. Return all data as a single massive string?