SQL Server Performance

Forum Subscriptions

Discussion in 'Forum Announcements' started by bradmcgehee, Aug 14, 2004.

  1. bradmcgehee New Member

    I am turning off forum subscriptions for a few days to see how they affect the forum's performance. I have been told that subscriptions may be responsible for the performance issues when responding to a post. By turning them off, you will not loose your current subscriptions, as they will return when they are turned back on.

    If we find that turning off the subscriptions helps performance, what should I do? Should I keep subscriptions turned off, for better performance, or on, for convenience?

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  2. Luis Martin Moderator

    Subscriptions is usefull but I prefer better performance, so turning off is ok to me.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

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

  3. derrickleggett New Member

    I don't ever use them, so it wouldn't bother me. I just make it a point to check the site regularly. I haven't seen any performance issues lately. What's been the problem? (I'm probably just pointing out the fact I don't get on here enough. lol)

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  4. satya Moderator

    Ah, this could explain the performance of Forums since this morning (for me!).

    Brad, for the sake of performance and not to loose the numbers its better to turn off the subscriptions and keep a word to email you if they wish to subscribe, I don't think there will be a flood of wishes to subscribe and its better for the orginator to comeback for update.

    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.
  5. FrankKalis Moderator

    Well, performance has improved. I guess, I have to change my habits now. I'm used to subscribtion and guess I'll miss a lot of interesting threads now.


    --Frank
    http://www.insidesql.de
  6. chopeen Member

    Without subscriptions I will miss many interesting threads.

    Did you think about some kind of batch subscriptions? I mean, why not send them once or twice a day during off-hours?

    --

    Marek 'chopeen' Grzenkowicz, MCP
    Poland
  7. FrankKalis Moderator

    Unfortunately, you can't do this in Snitz.
    You can only choose among different levels of subscription, but that's all.
    There might be a hack available, but, even if so, personally I wouldn't use it, since this will make future maintenance more difficult.

    --Frank
    http://www.insidesql.de
  8. Argyle New Member

    Since it's a snitz issue it should be submitted as a bug/issue to them so they could fix the performance problem for future versions.
  9. FrankKalis Moderator

    haha, that's good. <br />I've submitted several things to their forum. IIRC, I got only one response. Something like: "That's just the way it works". [<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
  10. bradmcgehee New Member

    This is difintely a tough issue.

    One option I could try, that may be a compromize between performance and getting posts via e-mail, is to only allow subscriptions to individual posts, and not to entire topics. This would reduce a lot of the e-mail, helping performance, but also allow people to be notified on specific issues. What do you think about this experiment? Is it worth it to try it out?

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  11. satya Moderator

    Brad

    I believe that will be good option to enable for a thread alone, rather than for whole forum section.

    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.
  12. FrankKalis Moderator

  13. Argyle New Member

    Isn't there a daily digest mode or something. That doesn't require mails to be sent at the same time when it's posted. I know people who have modem and find it too slow to surf so they use subscriptions instead to read the topics when they connect to the internet.
  14. chopeen Member

    quote:Originally posted by Argyle

    I know people who have modem and find it too slow to surf...

    I do not use modem and I have a decent connection, but I still find using a forum much slower than reading Usenet news. That's why I think that subscription is a great thing. And daily digest would be even more convenient than dozens of e-mails in my inbox every day.

    --

    Marek 'chopeen' Grzenkowicz, MCP
    Poland
  15. bradmcgehee New Member

    Unfortunately, the Snitz forum does not offer this ability, and I am not smart enough to write the modification.

    I checked, and there were over 1,400 subscriptions to the forum, at all levels. As an experiment, I turned on topic subscriptions only, and also deleted all of the old subscriptions.

    Let's try this awhile and see what happens.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  16. satya Moderator

    The performance seems to be OK and no change since you turned off the whole forum subscription option.

    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.
  17. chopeen Member

    quote:Originally posted by bradmcgehee

    As an experiment, I turned on topic subscriptions only...

    It is always better than no subscriptions.

    By the way, do you exactly what subscriptions cause performance problems? Is this an overhead caused by sending e-mails? Or is it caused by the neccesity of tracking a large number of subscriptions?

    --

    Marek 'chopeen' Grzenkowicz, MCP
    Poland
  18. FrankKalis Moderator

    Hey, you might want to visit<a target="_blank" href=http://www.snitz.com>http://www.snitz.com</a> , download the forum software for free and solve this problem. [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />The problem seems to be in inc_subscription.asp. A 15k file handling subscriptions. It's included in post.asp and called each time a post is made. Personally I think it's more the overhead of sending the mails than tracking any number.<br /><br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
  19. chopeen Member

    <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 />Hey, you might want to visit<a target="_blank" href=http://www.snitz.com>http://www.snitz.com</a> , download the forum software for free and solve this problem. [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Because of my work, I am not sure if something like 'free time' exists at all [<img src='/community/emoticons/emotion-2.gif' alt=':D' />], but I will try to take a look at it during the weekend. I never used Snitz, so I do not think I will be able to help, but it is always worth trying.<br /><br />--<br /><br />Marek 'chopeen' Grzenkowicz, MCP<br />Poland
  20. bradmcgehee New Member

    I also think it is the overhead of sending the mails. As each post is made, all of the e-mails have to be sent before the page is returned to the user.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  21. derrickleggett New Member

    What a dumb design. <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.
  22. FrankKalis Moderator

    Derrick answer reminds me, that SQLTeam runs the same forum software, doesn't it [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br />IIRC graz has also only enabled topic subscription, right?<br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />
  23. derrickleggett New Member

    I believe that's true.

    MeanOldDBA
    derrickleggett@hotmail.com

    When life gives you a lemon, fire the DBA.
  24. satya Moderator

    Yes it is, I believe Snitz is getting popular now a days with more clients.

    I believe the subscription to an individual post is an ideal solution than enable marking the whole forum (I think Frank will be cheesed off with my opinion)

    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.
  25. FrankKalis Moderator

    Well, I very flexible on this. Right now, I getting acquitant to have a browser instance open a let the active topics page refresh every 15 minutes or so. Does also quite a good job [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br /><br />--Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />

Share This Page