sorenchr Posted May 27, 2008 Share Posted May 27, 2008 Hi there, First of all, let me just say what great help this forum has been for me. There is tons of information goodies here and I really appreciate the help i have gotten from you guys so far. Now for my question. Suppose I have a website with a mainpage, lets say that it gets 3000 visits pr. day. The mainpage only calls one value from my mysql db, a notification to all visitors (which can be updated by admins) which is stored in a text format in the db. Now, I am wondering if i can somehow store this value somewhere else, so that a mysql query isn't made for every user that visits the site. I don't know much about mysql databases, neither their perfomance level on high-traffic sites, so would an alternative solution be the best(such as the one I have just described) or am I overreacting by underestimating the db's performance? Best regards Sorenchr Quote Link to comment https://forums.phpfreaks.com/topic/107501-easing-of-the-load-of-the-db/ Share on other sites More sharing options...
amites Posted May 27, 2008 Share Posted May 27, 2008 you could store the main page in the server cache, either in memory for getting really optimized, or in a pre-rendered version of the file which would be re-created when the admin changes the message make sense? Quote Link to comment https://forums.phpfreaks.com/topic/107501-easing-of-the-load-of-the-db/#findComment-551165 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.