I've done some experimenting with this too...
Consider the situation where:
1) The site consists of (almost) entirely dynamic content, where the
viewer sees pages generated from information in a database.
2) The site contains listings of products, suppliers, and corporate
information of third-party "customers" of the client... a "yellow
pages" for a specific industry.
3) This information is accessed through drill-down searches.
4) There is no charge for a standard listing. ,The client can sell
optional services (placement, links, logos, etc.) to his customers to
improve their visibility in the "yellow pages" when accessed by the
customers of the customers of the client.
The client needs to gather stats on how well the various "Yellow
Page" options perform, so he can sell the optional services...
something like:
Product xxx was retrieved 1000 times
Company yyy is one of 42 suppliers for product xxx.
Company yyy was shown as a candidate (in the list of potential suppliers)
90 times... the top supplier was shown 1000 times.
Company yyy specific information was retrieved 5 times... the top
supplier was
retrieved 600 times.
Company yyy was linked or mailed 0 times... the top supplier was
retrieved 200 times.
Company xxx has a standard listing, the top supplier has these $ options:
Placement
Logo
Mailto
Link to web site
Now, I wonder what we can do to improve the performance Supplier xxx?
For this requirement, standard stats are meaningless... hits on the
drill-down pages, oblivious to the content presented.
So, I began experimenting with logging (counting actually) to the db
(SQL Server 7.0)
During the drill-down suppliers are displayed in groups of 10 (next,
prev) ordered by options and Supplier name (The ones with the most
options appear at the top of the list)
Each of these 10 suppliers is logged as a candidate (10 log counts are updated)
Each next/prev logs another 10 suppliers.
If a specific supplier is selected for detail display,, it is logged
(a different counter is updated).
If a Link or mailto is selected from the detail page, yet another
counter is updated.
This gives me a set of counts that I can periodically use to generate
reports. etc.
The counts are updated with a single SQL query using T/SQL to
increment the current value... the overhead is not too bad.
This is not as robust as full logging, but it should the client
enough information to sell the optional services.
Steve, if you are doing full logging, I would be interested in any
measurements of the overhead associated with this logging.
Dick
At 9:40 AM -0400 8/30/00, Steve Nelson wrote:
>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/fusebo
>>x 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/fusebo
>x 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.
