Posted by Tom on 02/11/05 11:48

If your mysql server has access (or can have access) to the directory
where you want to dump the file, you can just use the "SELECT.... INTO
OUTFILE FIELDS TERMINATED BY ','..." syntax as your query, which is very
fast.

Mirco Blitz wrote:

>Hi,
>Probably the Pear Excel_Syltesheet_Writer works for you.
>http://pear.php.net/package/Spreadsheet_Excel_Writer
>
>I found out that it is faster with huge data sets on my system.
>
>Greetings
>Mirco
>
>-----Ursprüngliche Nachricht-----
>Von: Redmond Militante [mailto:r-militante@northwestern.edu]
>Gesendet: Freitag, 11. Februar 2005 00:02
>An: php-general@lists.php.net
>Betreff: [PHP] export mysql to csv prob
>
>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
>
>
>

[Back to original message]