Trying to speed up php output from mysql
| From: | Phin Pope | Date: | Tue, 17 Sep 2002 11:04:26 +0000 |
| Subject: | Trying to speed up php output from mysql | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21795@lists.php.net to get a copy of this message | ||
Hi,
I've got a script that I've written that writes out a xml file from
mysql via php.
The file should contain 250,000 xml style records, but it takes so long
to generate the file the process has to be stopped before complete.
I can't use mysqldump because of some of the processing that is required
on the fields after they are extracted.
Is there a faster way to write to a file than fwrite() or any other
bright ideas?
Phin
\\\___///
\\ - - //
( @ @ )
+------------oOOo-(_)-oOOo-------------+
| phin pope - phin@webnetism.com |
| Created for the benefit of all life |
| Web Development and Creative Insight |
| Webnetism Tel: +44 1452 855222 |
+---------------------Oooo-------------+
oooO ( )
( ) ) /
\ ( (_/
\_)
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.389 / Virus Database: 220 - Release Date: 16/09/2002