I'd recomment PHP4 using pconnect and MySQL. And I'd /not/ use locking on the table. Run a query to update the row, then run a select to grab the current total. In the case of a counter, it doesn't require the precision that most things would. (i.e., it's okay if the row you read doesn't have the value you just set in the update.)
As far as performance goes, my PHP app can do 40+ queries in less that .05 seconds. So you shouldn't have problems there. Good luck! Matthew Walker Senior Software Engineer ePliant Marketing -----Original Message----- From: Craig Westerman [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 14, 2002 8:17 PM To: MySQL List Subject: MySQL counter for HIGH traffic site I'm needing counter for site that receives 80 to 120 hits a minute at peak load. Many I have tried cause excessive server load and need to be deactivated or they lose data and return to zero without warning. All tried so far have been written in Perl writing to a file. Anyone here know of a counter that would handle HIGH traffic with little added server load? Would using MySQL to store count be of any benifit? Would Perl or PHP be faster for writing count to MySQL? Thanks Craig ><> [EMAIL PROTECTED] --------------------------------------------------------------------- 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.345 / Virus Database: 193 - Release Date: 4/9/2002 --------------------------------------------------------------------- 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
