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 >[EMAIL PROTECTED] > >On Mon, 8 Apr 2002 09:41:39 -0700, Jim Lucas [php] <[EMAIL PROTECTED]> 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" <[EMAIL PROTECTED]> > > To: "php-general-list" <[EMAIL PROTECTED]> > > 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 ><> > > > [EMAIL PROTECTED] > > > > > > > > > -- > > 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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
