I think calculating directly in MySQL will be faster, since less data will be "travelling" from MySQL to PHP. Just my 2¢. Regards, Rodolfo Andrade ----- Original Message ----- From: Weber Sites LTD To: 'Peter Lauri' ; php-general@xxxxxxxxxxxxx Sent: Wednesday, January 11, 2006 6:07 AM Subject: RE: Speed Why not check it? Try to query for the AVG() and get the result or query for the data and do a loop in PHP to calculate the AVG. Check the time each Takes. My Money is that getting the value from SQL will be faster. Sincerely berber Visit the Weber Sites Today, To see where PHP might take you tomorrow. PHP code examples : http://www.weberdev.com PHP Web Logs : http://www.weberblog.com/ PHP & MySQL Forums : http://www.weberforums.com/ Learn PHP Playing Trivia http://www.webertrivia.com Web Development Index http://www.weberindex.com Web Templates http://www.webertemplates.com Search for PHP Code from your browser http://toolbar.weberdev.com -----Original Message----- From: Peter Lauri [mailto:peter@xxxxxxxx] Sent: Wednesday, January 11, 2006 9:14 AM To: php-general@xxxxxxxxxxxxx Subject: Speed Best group member, Assume that I save data about an object and it has 10.000 observations of the object stored in a MySQL database. I want calculate the average value of a column, is it faster done by using PHP on the result array or using the MySQL function to do that? /Peter -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
