SQL Server Performance

I'm back!

Discussion in 'Forum Statistics' started by Luis Martin, Aug 23, 2007.

  1. Luis Martin Moderator

    As you probably know, I'm back. Slowly.
    Some numbers:
    31-05-07
    Frank: 6685
    Luis: 6263
    Mohamed: 2607
    Satya: Who cares? : 16793
    Members: 20577
    Posts: 109929
    23-08-07
    Frank: 7166
    Luis: 6382
    Mohamed: 3228
    Satya: (tired of this guy):18610
    Members: 21974
    Posts: 129377
    Don't ask me for conclusions!!![:p]
  2. FrankKalis Moderator

    Good to see you again. [:)]
    The results are a bit skewed due to the system switch. I believe many of us "lost" some posts. Most likely due to misrecorded statistics in Snitz.
  3. FrankKalis Moderator

    <P mce_keep="true">Now this is interesting. Luis is writing that I have 7,166 posts as of yesterday. Now are my first reply I see this:</P><TABLE class="" cellSpacing=0 cellPadding=0 width="100%" border=0><TBODY><TR vAlign=center><TD class="" align=left>08-24-2007 10:21 AM </TD><TD class="" align=right><A href="http://sql-server-performance.com/Community/forums/p/22676/129572.aspx#129572" mce_href="http://sql-server-performance.com/Community/forums/p/22676/129572.aspx#129572"><FONT color=#003b6e>In reply to</FONT></A> </TD></TR></TBODY></TABLE><TABLE class="" cellSpacing=0 cellPadding=0 width="100%" border=0><TBODY><TR vAlign=top><TD class=ForumPostUserArea rowSpan=2 class="ForumPostUserArea"><DIV class=ForumPostUserContent><UL class=ForumPostUserPropertyList><LI class=ForumPostUserName><IMG style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-RIGHT-WIDTH: 0px" alt="" src="http://sql-server-performance.com/Community/Themes/default/images/user_IsOnline.gif" mce_src="http://sql-server-performance.com/Community/Themes/default/images/user_IsOnline.gif"> <A href="http://sql-server-performance.com/Community/members/FrankKalis.aspx" mce_href="http://sql-server-performance.com/Community/members/FrankKalis.aspx">FrankKalis</A> <LI class=ForumPostUserAvatar><IMG style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; WIDTH: 80px; BORDER-BOTTOM: 1px solid" alt="" src="http://sql-server-performance.com/Community/users/avatar.aspx?userid=8208&amp;amp;amp;amp;lastmodified=633222635064218750" mce_src="http://sql-server-performance.com/Community/users/avatar.aspx?userid=8208&amp;amp;amp;amp;lastmodified=633222635064218750"> <LI class=ForumPostUserIcons><IMG title="Top 10 Contributor" alt="Top 10 Contributor" src="http://sql-server-performance.com/Community/Themes/default/images/rankicons/rankTop10.gif" mce_src="http://sql-server-performance.com/Community/Themes/default/images/rankicons/rankTop10.gif"> <LI class=ForumPostUserAttribute>Joined on 04-04-2003 <LI class=ForumPostUserAttribute>Germany <LI class=ForumPostUserAttribute>Posts&nbsp;<FONT color=#003b6e>7,166</FONT> <LI class=ForumPostRoleIcons><A href="http://sql-server-performance.com/Community/user/Members.aspx?search=1&amp;r=126375d9-717b-4b77-8135-a35947c1a388" mce_href="http://sql-server-performance.com/Community/user/Members.aspx?search=1&amp;r=126375d9-717b-4b77-8135-a35947c1a388"><IMG style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-RIGHT-WIDTH: 0px" alt="Microsoft MVP" src="http://sql-server-performance.com/Community/utility/roleicons/126375d9-717b-4b77-8135-a35947c1a388.jpg" mce_src="http://sql-server-performance.com/Community/utility/roleicons/126375d9-717b-4b77-8135-a35947c1a388.jpg"></A><BR><A href="http://sql-server-performance.com/Community/user/Members.aspx?search=1&amp;r=bb1e2b0d-83ab-4dbe-b46b-18c438128890" mce_href="http://sql-server-performance.com/Community/user/Members.aspx?search=1&amp;r=bb1e2b0d-83ab-4dbe-b46b-18c438128890"><IMG style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-RIGHT-WIDTH: 0px" alt=Moderator src="http://sql-server-performance.com/Community/utility/roleicons/bb1e2b0d-83ab-4dbe-b46b-18c438128890.jpg" mce_src="http://sql-server-performance.com/Community/utility/roleicons/bb1e2b0d-83ab-4dbe-b46b-18c438128890.jpg"></A> </LI></UL></DIV></TD><TD class=ForumPostContentArea class="ForumPostContentArea"><DIV class=ForumPostTitleArea><H4 class=ForumPostTitle>Re: I'm back! </H4><DIV class=ForumPostThreadStatus></DIV><DIV class=ForumPostButtons><A class="CommonImageTextButton CommonReplyButton" href="http://sql-server-performance.com/Community/forums/AddPost.aspx?ReplyToPostID=129585&amp;Quote=False" mce_href="http://sql-server-performance.com/Community/forums/AddPost.aspx?ReplyToPostID=129585&amp;Quote=False">Reply</A> <A class="CommonImageTextButton CommonDeleteButton" href="http://sql-server-performance.com/Community/forums/DeletePost.aspx?PostID=129585&amp;ReturnUrl=%2fCommunity%2fforums%2fthread%2f129572.aspx%23129585" mce_href="http://sql-server-performance.com/Community/forums/DeletePost.aspx?PostID=129585&amp;ReturnUrl=%2fCommunity%2fforums%2fthread%2f129572.aspx%23129585">Delete</A> <A class="CommonImageTextButton CommonEditButton" href="http://sql-server-performance.com/Community/forums/EditPost.aspx?PostID=129585&amp;ReturnUrl=%2fCommunity%2fforums%2ft%2f22676.aspx%23129585" mce_href="http://sql-server-performance.com/Community/forums/EditPost.aspx?PostID=129585&amp;ReturnUrl=%2fCommunity%2fforums%2ft%2f22676.aspx%23129585">Edit</A> <A class="CommonImageTextButton CommonFavoriteButton" onclick="return window.ctl00_ctl00_bcr_bcr_ctl00_PostList_ctl02_ctl17_ctl00_ServerPopulatedPopupMenu.LoadMenu(this, event, '8208:129585:41:Forum');" href="http://sql-server-performance.com/Community/forums/t/22676.aspx#" mce_href="http://sql-server-performance.com/Community/forums/t/22676.aspx#">Favorites</A> <A class="CommonImageTextButton CommonContactButton" onclick="return window.ctl00_ctl00_bcr_bcr_ctl00_PostList_ctl02_ctl18_ctl00_ClientPopulatedPopupMenu.LoadMenu(this,event,['8208','FrankKalis','0','1','http://www.familienzirkus.de','','','/Community/search/SearchResults.aspx?u=8208&amp;o=DateDescending'],null);" href="http://sql-server-performance.com/Community/forums/t/22676.aspx#" mce_href="http://sql-server-performance.com/Community/forums/t/22676.aspx#">Contact</A> <A class=CommonTextButton onclick="return window.ctl00_ctl00_bcr_bcr_ctl00_PostList_ctl02_ctl19_ctl02_ClientPopulatedPopupMenu.LoadMenu(this,event,['129585','41','1','2','0','1','8208','Moderated','%2fCommunity%2fforums%2f41.aspx'],null);" href="http://sql-server-performance.com/Community/forums/t/22676.aspx#" mce_href="http://sql-server-performance.com/Community/forums/t/22676.aspx#">Moderate</A> </DIV></DIV><TABLE class="" style="TABLE-LAYOUT: fixed" height="100%" cellSpacing=0 cellPadding=0 width="100%" border=0><TBODY><TR><TD class=""><DIV class=ForumPostBodyArea><DIV class=ForumPostContentText><P>Good to see you again. <IMG alt=Smile src="http://sql-server-performance.com/Community/emoticons/emotion-1.gif" mce_src="http://sql-server-performance.com/Community/emoticons/emotion-1.gif"></P><P>The results are a bit skewed </P></DIV></DIV></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><P>Isn't the post count updated immediately in CS?</P>
  4. Madhivanan Moderator

    He must have kept in mind about your reply in this thread [:)]
  5. Madhivanan Moderator

    <P mce_keep="true">I think so. It is not updated as soon as you we reply <P mce_keep="true">[quote user="FrankKalis"] <P>Now this is interesting. Luis is writing that I have 7,166 posts as of yesterday. Now are my first reply I see this:</P><TABLE class="" cellSpacing=0 cellPadding=0><TBODY><TR><TD class="" align=left>08-24-2007 10:21 AM </TD><TD class="" align=right><A href="http://sql-server-performance.com/Community/forums/p/22676/129572.aspx#129572"><FONT color=#003b6e>In reply to</FONT></A> </TD></TR></TBODY></TABLE><TABLE class="" cellSpacing=0 cellPadding=0><TBODY><TR><TD class=ForumPostUserArea rowSpan=2 class="ForumPostUserArea"><DIV class=ForumPostUserContent><UL class=ForumPostUserPropertyList><LI class=ForumPostUserName><IMG style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-RIGHT-WIDTH: 0px" alt="" src="http://sql-server-performance.com/Community/Themes/default/images/user_IsOnline.gif"> <A href="http://sql-server-performance.com/Community/members/FrankKalis.aspx">FrankKalis</A> <LI class=ForumPostUserAvatar><IMG style="BORDER-RIGHT: 1px solid; BORDER-TOP: 1px solid; BORDER-LEFT: 1px solid; WIDTH: 80px; BORDER-BOTTOM: 1px solid" alt="" src="http://sql-server-performance.com/Community/users/avatar.aspx?userid=8208&amp;amp;amp;amp;lastmodified=633222635064218750"> <LI class=ForumPostUserIcons><IMG title="Top 10 Contributor" alt="Top 10 Contributor" src="http://sql-server-performance.com/Community/Themes/default/images/rankicons/rankTop10.gif"> <LI class=ForumPostUserAttribute>Joined on 04-04-2003 <LI class=ForumPostUserAttribute>Germany <LI class=ForumPostUserAttribute>Posts&nbsp;<FONT color=#003b6e>7,166</FONT> <LI class=ForumPostRoleIcons><A href="http://sql-server-performance.com/Community/user/Members.aspx?search=1&amp;r=126375d9-717b-4b77-8135-a35947c1a388"><IMG style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-RIGHT-WIDTH: 0px" alt="Microsoft MVP" src="http://sql-server-performance.com/Community/utility/roleicons/126375d9-717b-4b77-8135-a35947c1a388.jpg"></A><BR><A href="http://sql-server-performance.com/Community/user/Members.aspx?search=1&amp;r=bb1e2b0d-83ab-4dbe-b46b-18c438128890"><IMG style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-RIGHT-WIDTH: 0px" alt=Moderator src="http://sql-server-performance.com/Community/utility/roleicons/bb1e2b0d-83ab-4dbe-b46b-18c438128890.jpg"></A> </LI></UL></DIV></TD><TD class=ForumPostContentArea class="ForumPostContentArea"><DIV class=ForumPostTitleArea><H4 class=ForumPostTitle>Re: I'm back! </H4><DIV class=ForumPostThreadStatus></DIV><DIV class=ForumPostButtons><A class="CommonImageTextButton CommonReplyButton" href="http://sql-server-performance.com/Community/forums/AddPost.aspx?ReplyToPostID=129585&amp;Quote=False">Reply</A> <A class="CommonImageTextButton CommonDeleteButton" href="http://sql-server-performance.com/Community/forums/DeletePost.aspx?PostID=129585&amp;ReturnUrl=%2fCommunity%2fforums%2fthread%2f129572.aspx%23129585">Delete</A> <A class="CommonImageTextButton CommonEditButton" href="http://sql-server-performance.com/Community/forums/EditPost.aspx?PostID=129585&amp;ReturnUrl=%2fCommunity%2fforums%2ft%2f22676.aspx%23129585">Edit</A> <A class="CommonImageTextButton CommonFavoriteButton" href="http://sql-server-performance.com/Community/forums/t/22676.aspx#">Favorites</A> <A class="CommonImageTextButton CommonContactButton" href="http://sql-server-performance.com/Community/forums/t/22676.aspx#">Contact</A> <A class=CommonTextButton href="http://sql-server-performance.com/Community/forums/t/22676.aspx#">Moderate</A> </DIV></DIV><TABLE class="" style="TABLE-LAYOUT: fixed" cellSpacing=0 cellPadding=0><TBODY><TR><TD class=""><DIV class=ForumPostBodyArea><DIV class=ForumPostContentText><P>Good to see you again. <IMG alt=Smile src="http://sql-server-performance.com/Community/emoticons/emotion-1.gif"></P><P>The results are a bit skewed </P></DIV></DIV></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><P>Isn't the post count updated immediately in CS?</P>[/quote]
  6. satya Moderator

    Oi Mr. Stats guru ... why not elevating me here [;)][:'(]
    Satya: Who cares? : 16793
    Glad to see you "active" here....
    Frank,
    It will take minimum of 3 seconds to update the count and if the corresponding SQL table is not optimized you will see delay in count. Also there will be a scheduled job running to update all the counters, so Jude has to check in this regard.
  7. FrankKalis Moderator

  8. satya Moderator

    I believe within CS there is a scheduled job runs every minute to update the count, sometime this can be modified as per the site usage. But since the beginning of site changeover here I don't see such problems.
    Only I tend to see my replies 'little' late on the speed of refresh between posts I reply.

Share This Page