0

hello all i am having a website where i have a side pannel which is displaying the same thing on all the pages i mean the data which is fetched by the database dosent change often. like i have a pannel on the left side of my site which is displaying recent birthdays which is going to be change after 1 day only but the problem is that everytime the page is refreshed the same data needs to be fetched from the database again and again which can increase the database load and also page load time

i was wondering if there is anything which can display the side bar once the query is executed and after that the result will be fetched from session/cache or what ever the sollution is

i think it can be done by cache like memcache but i dont know how i also tried to store them into session and cookies but there is error it say can not store objects into session and also i have to use loop to the results obtained by query the query is like 

  $birthday_query=mysqli_query($connection,"select name,email,id,date from members where dob 'some code here' "); 
   // this code fetches about 30-40 results and i am using the loop to display the results..
Rahul aman
  • 379
  • 3
  • 13

2 Answers2

1

Yes, you can use memcache to store the information. This is your best option as it is going to stay in the server memory.

You can also use something very simple like a temp file where to keep the recent birthdays information - the HTML code. Update the information in this file once a day and read it from there. For every user you can read the information once (when they first come the website) and then store it and read it from the session.

Yasen Zhelev
  • 4,045
  • 3
  • 31
  • 56
  • i am very new to memcache can you please tell me how to start with memcahce ... i am not asking you to teach me but just a startup and connections etc... – Rahul aman Apr 12 '15 at 07:11
  • There are multiple tutorials on Internet about this. For example: http://code.tutsplus.com/tutorials/turbocharge-your-website-with-memcached--net-23939 – Yasen Zhelev Apr 12 '15 at 07:20
1

For just 30-40 results, you don't need caching it will not add a great value, good will be to use Session to store the data as soon user browse your first page and then fetching data always from Session. using a file to cache html is also a good bet here.

you can check how to store object into session

Community
  • 1
  • 1
Kuldeep Dangi
  • 4,126
  • 5
  • 33
  • 56
  • It may be 30-40 results only but running this query (any repetitive query) on every page load af a busy site is not recommended. – Yasen Zhelev Apr 12 '15 at 07:11
  • I never said to run the same query on every page. My point here is `Session` is a good bet over caching for this scenario. – Kuldeep Dangi Apr 12 '15 at 07:13