Re: counter for HIGH traffic site

If it should be fast, avoid using mysql, just write a file with your number, if there´s a new request, get your number, add one and write it back. So you avoid mysql-"SQL parsing", opening Database, searching data, send to process, php putting in var....... just open, read, add, write, close HTH Oliver At 08.04.2002 14:32, you wrote:

You might also want to setup the table your updating the hits in as a HASH type table which runs completely in RAM, and as a result is extremely fast. The only obvious downside, is the data (or hits in this case) are lost on reboot. Adam Voigt adam.voigt@cryptocomm.com On Mon, 8 Apr 2002 09:41:39 -0700, Jim Lucas [php] <jimphp@bend.com> wrote: as long as you are only inserting information into the mysql db on each page load, then you shouldn't have a problem. make sure you keep you indecies down to a minimum. Jim Lucas ----- Original Message ----- From: "Craig Westerman" <westerman@chanuteks.com> To: "php-general-list" <php-general@lists.php.net> Sent: Saturday, April 06, 2002 11:57 PM Subject: [PHP] counter for HIGH traffic site

I'm needing counter for site that receives 60 to 80 hits a minute. 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. Anyone here know of a PHP counter that would handle HIGH traffic with

little

added server load? Would using MySQL to store count be of any benifit? Thanks Craig ><> westerman@chanuteks.com

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php