hi
i have a script that exports the result of a mysql query to a csv file suitable for downloading
the code looks like
$result = mysql_query("select * from user,mjp1,mjp2,mjp3,mjp4");
while($row = mysql_fetch_array($result)) {
$csv_output .= "$row[userid] $row[firstname] $row[lastname]\n" }
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".xls");
print $csv_output;
this works fine, except that when i expand the line
$csv_output .="$row[userid] $row[firstname] $row[lastname] $row[anotherfield] $row[anotherfield] ...\n"}
-to include an increasing number of fields, it tends to bog down the speed at which the $csv_output file can be printed. when i have this line output 30+ fields for each row, wait time for output file generation is almost 4-5 minutes.
is this the most efficient way to do this? i'd like to be able to generate the file as quickly as possible.
thanks
redmond
--
Redmond Militante
Software Engineer / Medill School of Journalism
FreeBSD 5.2.1-RELEASE-p10 #0: Wed Sep 29 17:17:49 CDT 2004 i386
4:45PM up 4:01, 3 users, load averages: 0.00, 0.00, 0.00
Attachment:
pgpOMsD2Yd2zv.pgp
Description: PGP signature
