I was just speaking tongue-in-cheek since I had major problems with
db-stored (MS SQL Server 7.0) client vars on said site. The machine was a
quad PIII-500 with 1GB of RAM connected to other servers via local net. I'm
sure there was some tweaking that could have been done, but after 30
seconds, the db machine was maxing out and so was the app server (cpu-wise).
Tried a number of settings, found that I had to separate db-intensive app
from process intensive app, and set the db intensive cf-server to handle 450
simultaneous conns, at which point everything was hunky-dory.
The problem was that with the usual 15-20 conns, the requests were coming in
faster than CF was handling them - MUCH faster.
Look forward to seeing what you come up with!
__________________________________________
Chris Chambers
ICQ: 40311211
MSN: webdood
AIM: CTC HOME
Vox: 757-896-6393
Fax: 757-896-0774
__________________________________________
-----Original Message-----
From: Steve Nelson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 30, 2000 11:01 AM
To: [EMAIL PROTECTED]
Subject: Re: CF based web stats
I'm pretty sure, you still wouldn't have to wait....
Every hit is thrown into an application query, that application query is
dumped to a file, which is then bulk inserted into the database every X
minutes. Then to view the stats for that page it's just a matter of
running the appropriate query.
Sure, it may be a little slow for that many hits, but that all depends
on the database you're using. I'd be very interested to see how well it
does work for this many hits.... i honestly have no idea.
btw, I built it so you could drill down to view stats, it starts out by
listing hits/month, then you choose a month, it shows hits per/day in
that month, then you click a day and it shows hits/hour in that day.
Steve
Chris Chambers wrote:
>
> hehe you won't have to wait for hours to run the report until you start
> getting 1M+ hits a day...
>
> __________________________________________
>
> Chris Chambers
>
> ICQ: 40311211
> MSN: webdood
> AIM: CTC HOME
>
> Vox: 757-896-6393
> Fax: 757-896-0774
> __________________________________________
>
> -----Original Message-----
> From: Steve Nelson [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 30, 2000 9:41 AM
> To: [EMAIL PROTECTED]
> Subject: Re: CF based web stats
>
> i've started experimenting with bypassing webserver logs and just
> logging every hit myself into the database. By doing this I can see a
> dynamic log reports on every page (for properly secured people). So, no
> more waiting for hours for a log report tool to give you crappy reports.
>
> But the truly cool thing is that instead of running reports based on IP
> address, I can run reports based on the #client.user_id# or
> #client.cfid#/#client.cftoken# So it's designed to give incredibly
> powerful reports.
>
> It's still in the very beginning stages, i've only put about 3-4 hours
> into it, if any of you that are coming to conference want a
> demonstration, let me know.
>
> I demonstrated this to my dad and he said: "Is there a billion dollar
> company that does this same thing?" haha
>
> Steve
>
> Todd Hartle wrote:
> >
> > Any know of a CF based web server log analyzer?
> >
_________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
> >
> > Share information about yourself, create your own public profile at
> > http://profiles.msn.com.
> >
>
> --------------------------------------------------------------------------
> ----
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> --------------------------------------------------------------------------
--
> --
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> --------------------------------------------------------------------------
----
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
