Re: Trying to speed up php output from mysql

Does your process hang or simply is too long? Perhaps the limiting factor is not the writing speed, but a memory requirement problem. Try to compute how long it should take: - do your row processing after a SELECT ... LIMIT 1000 clause - time how long it takes, and extrapolate Then you will know. Ignatius ____________________________________________ ----- Original Message ----- From: "Phin Pope" <phin@webnetism.com> To: <php-db@lists.php.net> Sent: Tuesday, September 17, 2002 1:04 PM Subject: [PHP-DB] Trying to speed up php output from mysql > 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 > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >