|
|
Posted by Peter Fox on 10/09/06 09:23
Following on from windandwaves's message. . .
>Hi Folk
>
>I am running a site (A) that has a US mirror (B). This means that all
>the data from A is copied daily to B.
>
>On the site, I keep some statistics of the pages people visit, tracking
>them with a session and noting their searches, etc... for statistical
>purposes.
The 'statistical purposes' bit is the clue.
You don't need real-time data reporting. That's a relief because what
happens when site A is down for maintenance and site B is on-line?
Try something like:
PrintToStatsLog(UserId,PageId,GetSiteId());
where the log would be local to each system.
This could be in raw form 4,5,B...6,7,A etc or ready to run SQL
(printf-ing instead of doing a live query.)
You can now read these in when it's convenient.
Putting things in log files gives is an opportunity to think more about
your data eg
* perhaps weed page-backs (Systems view: It's not a new visit)
* perhaps identify page-back (User view : No that's not what I wanted)
* perhaps identify page-backs (Returned to page may be one of the more
useful ones)
* perhaps measure how long it takes people to find what they're looking
for.
I'd put a timestamp on as well.
I'd also make sure any search terms were sanitized before letting them
anywhere near a database.
--
PETER FOX Not the same since the e-commerce business came to a .
peterfox@eminent.demon.co.uk.not.this.bit.no.html
2 Tees Close, Witham, Essex.
Gravity beer in Essex <http://www.eminent.demon.co.uk>
Navigation:
[Reply to this message]
|