Counter script

On Fri, 07 Nov 2003 15:59:43 +0100, M. wrote:

 > Hey all,
 > I have been searching the hotscripts for the last few hours
 > and I found nothing really good. Grrrrr.
 >
 > I need a php script(s):
 > - download count
 > - users online (live)
 > - counter that can be set to count several pages, separately...
 >
 > MySQL is a must.
 >
 > Can any of you guys & gals recommend me a really good script(s) that
 > does this, please.

For heavy traffic sites, a counter attached to a database is not a good
idea.


--
Karim
<a style='text-decoration: underline;' href="http://www.cheapesthosting.com/webmastertoolbox" target="_blank">http://www.cheapesthosting.com/webmastertoolbox</a> - Free Resources for
Webmasters<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Counter script 

Karim wrote:

 > For heavy traffic sites, a counter attached to a database is not a good
 > idea.

Even if some of the IPs in the database are deleted after X amount of time?

--
Dale,
<a style='text-decoration: underline;' href="http://www.oxygenkiosk.net" target="_blank">www.oxygenkiosk.net</a>
Now playing: Winamp stopped<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Counter script 

On Fri, 07 Nov 2003 15:40:42 +0000, Firky wrote:

 > Karim wrote:
 >
  >> For heavy traffic sites, a counter attached to a database is not a good
  >> idea.
 >
 > Even if some of the IPs in the database are deleted after X amount of time?

Everytime a page gets hit, a database connection is needed and a database
insert is done. Collectively, this takes some resources (and I don't know
how MySQL is optimized) and you might get database locking issues.
It would be faster to save your info in a file and later do reports on it
or import all data into the database in one shot.


--
Karim
<a style='text-decoration: underline;' href="http://www.cheapesthosting.com/webmastertoolbox" target="_blank">http://www.cheapesthosting.com/webmastertoolbox</a> - Free Resources for
Webmasters<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Counter script 

Karim wrote:
 >
 > On Fri, 07 Nov 2003 15:40:42 +0000, Firky wrote:
 >
  > > Karim wrote:
  > >
   > >> For heavy traffic sites, a counter attached to a database is not a good
   > >> idea.
  > >
  > > Even if some of the IPs in the database are deleted after X amount of time?
 >
 > Everytime a page gets hit, a database connection is needed and a database
 > insert is done. Collectively, this takes some resources (and I don't know
 > how MySQL is optimized) and you might get database locking issues.
 > It would be faster to save your info in a file and later do reports on it
 > or import all data into the database in one shot.
 >
 > --
 > Karim
 > <a style='text-decoration: underline;' href="http://www.cheapesthosting.com/webmastertoolbox" target="_blank">http://www.cheapesthosting.com/webmastertoolbox</a> - Free Resources for
 > Webmasters


Karim,

The problem with writing to a file is the multithreading nature of the
web server can corrupt the file. MySql is made to handle this - and
does so quite well. Sure, there is a little overhead - but not as much
as you would think.



--

To reply, delete the 'x' from my email
Jerry Stuckle,
JDS Computer Training Corp.
jstucklex.TakeThisOut@attglobal.net
Member of Independent Computer Consultants Association - <a style='text-decoration: underline;' href="http://www.icca.org" target="_blank">www.icca.org</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Counter script 

Karim <karim3411 DeleteThis @yahoo.moc> wrote:

 >For heavy traffic sites, a counter attached to a database is not a good
 >idea.
I know.
Client's site is not under heavy traffic, so...

tnx<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Counter script 

Firky <bottle.of.dog.DeleteThis@brownale.com> wrote:

 >As found on hotscripts:
I seem to have missed this one...


 >http://www.silver-scripts.de/scripts/silvercounter.php?l=en
 >Pretty good, used to use it myself. HTH.

Yep, quite good.
Too bad it cant be set to count each page separately...

Tnx anyway Firky.

Regards
m.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Counter script 

M. wrote:
 > Hey all,
 > I have been searching the hotscripts for the last few hours
 > and I found nothing really good. Grrrrr.
 >
 > I need a php script(s):
 > - download count
 > - users online (live)
 > - counter that can be set to count several pages, separately...
 >
 > MySQL is a must.
 >
 > Can any of you guys & gals recommend me a really good script(s) that
 > does this, please.
 >
Try <a style='text-decoration: underline;' href="http://www.ekstreme.com" target="_blank">http://www.ekstreme.com</a>
no MySQL but it works nice

--
Duende
<a style='text-decoration: underline;' href="http://wipkip.us" target="_blank">http://wipkip.us</a>
<a style='text-decoration: underline;' href="http://wipkip.biz" target="_blank">http://wipkip.biz</a><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Counter script 

Karim <karim3411.DeleteThis@yahoo.moc> wrote in message news:<6mmvrntsylr0$.1mwggbd20yvj$.dlg@40tude.net>...
 > On Fri, 07 Nov 2003 15:40:42 +0000, Firky wrote:
 >
  > > Karim wrote:
  > >
   > >> For heavy traffic sites, a counter attached to a database is not a good
   > >> idea.
  > >
  > > Even if some of the IPs in the database are deleted after X amount of time?
 >
 > Everytime a page gets hit, a database connection is needed and a database
 > insert is done.

yes - that would be correct.

 >Collectively, this takes some resources

yes - correct again.

 > (and I don't know how MySQL is optimized)


You don't? Hmm...

 >and you might get database locking issues.

Why? A script to insert into a database should not need to acquire
any locks. If you're talking about a resource issue - ie, the number
of processes which can simultaneously connect to the database, then
that's not a "locking issue".

 > It would be faster to save your info in a file and later do reports on it
 > or import all data into the database in one shot.

No - I don't think it would. That would be ONE method though... not a
particularly bright one... but hey... it's all about choice....

Greg<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Counter script 

M. wrote:

 > Yep, quite good.
 > Too bad it cant be set to count each page separately...

I`m sure you could just tweak it

 > Tnx anyway Firky.
 >
 > Regards
 > m.


--
Dale,
<a style='text-decoration: underline;' href="http://www.oxygenkiosk.net" target="_blank">www.oxygenkiosk.net</a>
Now playing: Winamp stopped<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Counter script 

Karim wrote:

 > Everytime a page gets hit, a database connection is needed and a database
 > insert is done. Collectively, this takes some resources (and I don't know
 > how MySQL is optimized) and you might get database locking issues.
 > It would be faster to save your info in a file and later do reports on it
 > or import all data into the database in one shot.

Hhmm still not convinced, the work that MySQL does is very little I
would assume for this task. But I guess if you're talking hundreds of
people a minute or a second even...


--
Dale,
<a style='text-decoration: underline;' href="http://www.oxygenkiosk.net" target="_blank">www.oxygenkiosk.net</a>
Now playing: Winamp stopped<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Counter script