Quote:
Originally Posted by Admin
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
