SQL Server Performance

Active Members

Discussion in 'Please Tell Us What You Think' started by satya, Aug 27, 2004.

Page 1 of 2

  1. satya Moderator

    Brad

    Is it possible to provide a list or count of current active members on the forum, like in Dbforums.

    satya, Aug 27, 2004
    #2

  2. bradmcgehee New Member

    That's a good question, and I don't know the answer. I do have the ability to track all of the active sessions on the entire website, but I don't know how easy it would be to do so for only the forum. I imagine it is possible. Does anyone have any suggestions on how this can be easily done?

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
    bradmcgehee, Aug 27, 2004
    #2

  3. Luis Martin Moderator

    What current active members means?
    Some number of post by month?. Member without post from n months?.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

    Luis Martin, Aug 27, 2004
    #2

  4. bradmcgehee New Member

    It means how many people are currently logged into the forum.

    I forget to mention, that during a typical workday, there are about 500 or so active connections on average to the entire website. The busiest I have seen it is just over 1,000 active users.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
    bradmcgehee, Aug 27, 2004
    #2

  5. FrankKalis Moderator

    FrankKalis, Aug 30, 2004
    #2

  6. bradmcgehee New Member

    Thanks Frank. I have added the modification, and you can see it at the bottom of the home forum screen. Let me know if anyone runs into any bugs, or if this feature introduces any performance drag on the forum

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
    bradmcgehee, Aug 30, 2004
    #2

  7. satya Moderator

    Thanks for quick turnaround Brad and to Frank as well...
    It looks great on the main page and nothing seems to be changed on the Performance of the forum.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Aug 31, 2004
    #2

  8. FrankKalis Moderator

    Brad,<br />no performance penalty here. I think we can hardcode "satya" in that list [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
    FrankKalis, Aug 31, 2004
    #2

  9. satya Moderator

    [8D]sure ... between GMT 07:45 to 16:00....[<img src='/community/emoticons/emotion-2.gif' alt=':D' />][<img src='/community/emoticons/emotion-2.gif' alt=':D' />][<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by FrankKalis</i><br /><br />Brad,<br />no performance penalty here. I think we can hardcode "satya" in that list [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
    satya, Aug 31, 2004
    #2

  10. FrankKalis Moderator

    FrankKalis, Aug 31, 2004
    #2

  11. satya Moderator

    ... nah.. exclude weekends... definetly... chance for others to score. [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
    satya, Aug 31, 2004
    #2

  12. satya Moderator

    Brad

    How about including this on the Active topics screen as well, if you feel this is beyond your time or disturbs any format then don't put yourself out to do so.

    Thanks.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Aug 31, 2004
    #2

  13. bradmcgehee New Member

    That's not a feature of the mod installed, and I am not smart enough to figure out how to modify the forum's code to add this feature myself.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
    bradmcgehee, Aug 31, 2004
    #2

  14. FrankKalis Moderator

    Even if so, would be a real pain when you're about to upgrade in the future.
    I experience this here myself. I use mambo as my cms and said to myself to cahnge a little as possible to the core package to make update and upgrades fairly easy. Now I find myself maintaining a list of some 30 points to carefully consider when thinking about a update to the core. Sigh!


    --
    --Frank
    http://www.insidesql.de
    FrankKalis, Aug 31, 2004
    #2

  15. satya Moderator

    satya, Aug 31, 2004
    #2

  16. derrickleggett New Member

    Brad, the upgrade looks great. Thanks. <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />MeanOldDBA<br />derrickleggett@hotmail.com<br /><br />When life gives you a lemon, fire the DBA.
    derrickleggett, Aug 31, 2004
    #2

  17. Luis Martin Moderator

    I was thinking about Satya question and I understand the complications to implementate.
    How about last member post and new Member?

    Some times (most of the times) I have Active Topics open, and when grow I can't follow in easy way if someone made some new (not 0 answer) post, may be in response to my post.

    May be with last member post and new Member will be easy to follow up.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

    Luis Martin, Sep 15, 2004
    #2

  18. bradmcgehee New Member

    Unless the code is changed a lot, I don't know how this can be done. Luis, you want to volunteer to rewrite the code? [<img src='/community/emoticons/emotion-4.gif' alt=':p' />]<br /><br />-----------------------------<br />Brad M. McGehee, MVP<br />Webmaster<br />SQL-Server-Performance.Com
    bradmcgehee, Sep 15, 2004
    #2

  19. Luis Martin Moderator

    Brad, until friday, no jokes are permited in this forum[<img src='/community/emoticons/emotion-5.gif' alt=';)' />].<br /><br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br />
    Luis Martin, Sep 15, 2004
    #2

  20. satya Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by LuisMartin<br />I was thinking about Satya question and I understand the complications to implementate.<br />How about last member post and new Member?</i><br />On the main page of forum we have this information of last post updated by a member and wecolme to new member.<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />The only way to track the posts with updation is to use Active topics and set the time to refresh to every 2 minutes.[<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com/forum>http://www.SQL-Server-Performance.Com/forum</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>
    satya, Sep 20, 2004
    #2

  21. Luis Martin Moderator

    Hey!!!, I'm not a new member!!!!![<img src='/community/emoticons/emotion-4.gif' alt=':p' />][:0]<br />I allready use in that way, but suppose the following: I visit two customer per day. I work in each customer about 4 to 5 hours. First customer has not internet. When I open the forum in second customer there is at least 20 or more active post. <br />I began to see every one. I answer (just and example) 5. The others 20 still there. <br />Is difficult (not imposible) to find if one of the post I don't participate, has other new question o need some more information.<br /><br />Ok. Not a big deal, was just a suggestion[<img src='/community/emoticons/emotion-1.gif' alt=':)' />].<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><font size="1">All postings are provided “AS IS” with no warranties for accuracy.</font id="size1"><br /><br />
    Luis Martin, Sep 20, 2004
    #2
Page 1 of 2

Share This Page