Forum OpenACS Development: Re: Get number of visitors currently browsing the site

Collapse
6: Re: Get number of visitors currently browsing the site (response to 5)
Posted by Lars Pind on 05/06/04 09:18 PM
Yes, IP is unreliable. Any better suggestions?

Session_id, maybe?

/Lars

Collapse
7: Re: Get number of visitors currently browsing the site (response to 6)
Posted by Bruno Mattarollo on 06/29/04 06:45 PM

I guess that the problem with session_id is that it will also count the spiders, etc (I mean, everything accessing the site).

Something like: 

set ten_min_ago [expr [ns_time] - (10*60)]
set sql_query "select count(distinct session_id) 
    as result from sec_session_properties where last_hit > :ten_min_ago"
db_1row select_sessions $sql_query
should give you some sessions. The only issue that I see is that, at least in OpenACS 4.6.3 (that's what we are using at the moment) you don't have an index on sec_session_properties(last_hit) so this query is quite inefficient (but I am not sure than adding an index is also a good solution, this table is touched a lot -for every hit, right?-).

Just my 2 cents,

/B

Collapse
8: Re: Get number of visitors currently browsing the site (response to 7)
Posted by Jade Rubick on 06/29/04 07:11 PM
Perhaps we could cache the results every minute, and average them or something? The number doesn't have to be 100% accurate, but it should give a general idea of how many people are using the site.
Collapse
9: Re: Re: Get number of visitors currently browsing the site (response to 8)
Posted by Joel Aufrecht on 12/11/04 04:09 AM
I tried Bruno's query and find that I get 0 sessions even if there is an active member session.