PHP Code

[mike_w]

This probably won't get (m)any replies, but I'll ask anyway!

Does anybody have any tips on the best way to write PHP code, particularly on the speed of the code? For example, is it better to store a date fully (e.g. Saturday 5th November 2005) in MySQL, or store it as a datetime, and then get PHP to convert it to the format I want? (I have it the latter way right now - better in case I want to change it?) At the moment, pages are generated in up to 0.5 seconds.

Thanks

Mike

[Dav0s]

it will be quicker to use a timestamp and convert using date()

[Agent]

I did a simple caching script not too long back for my mini CMS.
Ive just found this which looks pretty good at explaining it. Im pretty sure thats all fairly basic to you, but its worth looking at.

http://www.sitepoint.com/blogs/2005/...optimizations/ also has some info on " vs ' - not a massive difference though.
The odd thing at http://www.e-gineer.com/v1/articles/...s-paradise.htm too.

Although, when i was trying to optimise, nearly all the [significant] time savings came from better SQL querys and the database side of things.

[Norky]

it will be quicker to use a timestamp and convert using date()

That's what I do. If you start using pre-formatted dates you end up having to parse them using regex etc. if you want the data from them.

[Ramedge]

i also use the timestamp function on the mysql side and just tell it how to format it in the table so i dont have to write any code for it in the front end.

[mike_w]

I did a simple caching script not too long back for my mini CMS.
Ive just found this which looks pretty good at explaining it. Im pretty sure thats all fairly basic to you, but its worth looking at.

Fairly basic? I've barely started learning! The caching looks quite good - I'll try implementing that at some point.

Although, when i was trying to optimise, nearly all the [significant] time savings came from better SQL querys and the database side of things.

Interesting... anybody have any tips for the MySQL side of things?

[TheAnimus]

if your worried about performance, take a look at Zend optomiser, or better yet phlanger (PHP compiler for .net environments).

if you really must have performance, then don't use PHP, its showing its age now, but its great for quickly nocking up small sites.