I'm currently developing a highly dynamic and modular system which requires attributes for 'styles' and 'site definition', even 'page title' to be returned on page load.
Whats the most effective way to get this data?
currently the data is retrieved on each page load from a mysql database (whoa! overhead!).
should I:
Work out which data is semi static (such as page colours, page titles on majority of pages.) then:
1a. Serialise all the common data and store it in mysql for retrieval on each load (one query is better than 10 i guess).
1b. Same as above but use flat file for serialized data.
there was going to be a 2. but I can't remember it.
any ideas? any help / pointers would be appreciated.
