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? Link to comment https://forums.phpfreaks.com/topic/70602-better-way/ 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.... Link to comment https://forums.phpfreaks.com/topic/70602-better-way/#findComment-355017 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.