Re: [PHP-DB] Performance Improvements

2002-02-23 Thread Bogdan Stancescu
Also, do you really need all those trim()'s? Maybe at least you could replace them with ltrim()'s or rtrim()'s - I don't know what your data is, but maybe you can pre-parse it? (i.e. keep the data trimmed in the db). All of the if ($something > 0) can generally be changed to if ($something) -

Re: [PHP-DB] Performance Improvements

2002-02-23 Thread Bogdan Stancescu
My first suggestion: replace all split() calls with explode() calls. Bogdan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Performance Improvements

2002-02-23 Thread Lee Leahu
Hello, Currently the following section of code is taking over 30 seconds to complete. It basically returns from a database 30,000 records. What changes do any of you recommend that would speed of the following code? Thank you , lee leahu [EMAIL PROTECTED] while ($row = mysql_