Hi, On a large database where speed is very important is it better to format the date using the MySQL DATE_FORMAT function in a query or to retrieve the date and then use PHP to format the date?
Currently the site is using the MySQL DATE_FORMAT function but I've been told it is better to use PHP date functions for speed improvements. The site depends upon the date quite a lot and it would take much work to change all the queries and use PHP for the formatting but it would be worth doing if it resulted in an increase in speed. I would welcome your views on this. Thank you very much. Janet [Non-text portions of this message have been removed]
