I want to create a PHP variable that is filled from the data of DataBase. I want to avoid the query to the database every request since it content is constant over every week, so it is not completly constant. Maybe there are some kind of variables, like $_SESSION, but that retain it content for every request and every user.
What strategy would you recommend?
Thanks a lot.
分享 On the PHP side you could use Memcache (or Memcached) to store variables in the server memory and use that to avoid frequent trips to the database for the same data.
On the database side, there may also be caching options that least alleviate the load on the DB server if it needs to respond to the same query and data has not changed. In MySQL, this is called the Query Cache, but other database might have similar variations.
分享
