jaymc Posted September 25, 2007 Share Posted September 25, 2007 If you have a large table with 50,000+ rows and you want to offer a script that will output the number of members tnhat match a criteria, for instance, last actibity to generate a whosonline.. is it better to have a cron job for instance query the main members table, pull out the matches which will usually be 600, and put them in a seperate table? Or will it be fine to query the the larger database for the info when ever a member requests.. Lets say its requested twice a minute.. Is it worth the hastle? Quote Link to comment Share on other sites More sharing options...
fenway Posted September 25, 2007 Share Posted September 25, 2007 Same question as before, eh? If you can generate summary tables, do so.... Quote Link to comment 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.