Reading from PHP file or Database (which is faster?)

[eluser]drewbee[/eluser]
To iterate further on query cache and file accessing.

Query Cache removes the need to make the actual call to the database - reducing load on the server.

Their is no 'locating or searching' of the query cached file - it knows exactly where it is. Each file only contains the serialized result set of said cached query. Trust me ~ Complex enough queries, especially ones that are called many times with no altercations in the query are far better off being stored elsewhere. This, naturally, only becomes a problem once heavy loads start to hit your DB server though.

For instance, I use query cache for anything along the lines of categories, collection of posts, events etc. Something that will not be continually changing. If I can avoid any calls to the database server, you can believe it will be done