> But what if concurrent inserts are happening to the table while the > users page-view thru the data. The count may change.
True, in my situation that is not a big concern. In yours it may. You can either expire the cached value every so often or run two queries on each hit. If you're expecting even nominal use of these pages the two-query option isn't as bad as it sounds. Remember that your OS with cache the disk access. The first time it may be slow but subsequent requests will be faster. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php