Welcome to WebmasterWorld Guest from 220.127.116.11
The users will be able to change the settings via a control panel function which will then be stored in a mysql database.
That bit is fine but I don't know which is the best method of retrieving and acting upon that data.
1. User changes the default look and feel of reports in their control panel.
2. User requests a report.
3. User Database is queeried and user settings returned.
4. Report database queeried and a report generated in the users required format.
It is option 3. which I think is a bit of a waste. Every time the user requests a report his settings are called from the user database.
Is it best to load the users settings when he first logs in? Would this be done in cookies or sessions?
There would be around 20 parameters which would be stored. I'm looking for the most efficient way of handling this.