Welcome Guest, Not a member yet? Register   Sign In
User Preferences + Database
#1

[eluser]boxyee[/eluser]
I'm working on a small project which requires the use of user preferences, such as currency and timezone etc. At the moment I have this stored on my database and is requested on page load. However I am worried about how this may affect performance if there were many users.

Are there any better solutions, or am I being worried for no reason??

Thanks,
#2

[eluser]WanWizard[/eluser]
Use a caching library, such as the one from Phil Sturgeon, and cache the query results on disk.
#3

[eluser]boxyee[/eluser]
[quote author="WanWizard" date="1289968455"]Use a caching library, such as the one from Phil Sturgeon, and cache the query results on disk.[/quote]

Thanks!! Will definately do that. Also saw the multicache library for memcache and APC, would you recommend that over the file caching?
#4

[eluser]WanWizard[/eluser]
Depends on the volume of data and the amount of memory in your server. It is definately going to be faster.




Theme © iAndrew 2016 - Forum software by © MyBB