Desi Forums - View Single Post - Display of Members Celebrating Their Birthdays!
View Single Post
  #12 (permalink)  
Old 06-04-2007, 03:44 AM
AaDi's Avatar
AaDi AaDi is offline
Premium Member
Location: United Kingdom
Gender:
Visit AaDi's Blog
 
Join Date: Nov 2005
Age: 24
Posts: 1,926
Credits: 8,284
AaDi is a jewel in the roughAaDi is a jewel in the roughAaDi is a jewel in the roughAaDi is a jewel in the rough
Quote:
Originally Posted by Admin View Post
Aadi, that'd require large table scans everytime the page is loaded.
dere is no point in querying it everytime .. once a day is enough .. a really cheap hack over the top of ma head is to use a file type of TEXT .. a quick query that extracts user on a specific date and stores them in that field ..something like .. Aadi, Endurer, etc .. now weneva the index loads, it just dumps the contents of that field ..

We can be really clever and store *all* the HTML code required for producing the usernames (like age and a link to profile etc) ..and ofcourse .. u can make dat query a cron and run it once a day wich basically updates that row with new entries ..

finally from ma experience of working with MySQL .. what i've mentioned might just take 2 seconds to produce and da the end result mysql_query time is going to be less that 0.02 seconds
Reply With Quote