SQL Server Performance

Double-post

Discussion in 'Please Tell Us What You Think' started by satya, Nov 24, 2003.

Page 1 of 2

  1. satya Moderator

    Brad

    Is there any issue with Forum software?
    As I can see few threads double-posted and even it happens to my replies in few threads.


    Thanks.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
    satya, Nov 24, 2003
    #2

  2. Luis Martin Moderator

    I see same problem, since saturday.


    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
    Luis Martin, Nov 24, 2003
    #2

  3. Luis Martin Moderator

    It happens to me now. Last response was duplicated with 2 minuts difference.


    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
    Luis Martin, Nov 24, 2003
    #2

  4. bradmcgehee New Member

    This seems to happen when people click on the post button twice, before the webpage returns. I have actually done this myself more than once, and I had to delete the double posts. This is the only way this can happen, that I am aware of.

    Also, this weekend, I noticed the forum was a little slow, but it appears faster now. My SQL Server is on a hosted server with my hosting company, and perhaps they were doing some maintenance or something this weekend. This may have contributed to some of the double posts.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
    bradmcgehee, Nov 24, 2003
    #2

  5. FrankKalis Moderator

    FrankKalis, Nov 24, 2003
    #2

  6. satya Moderator

    Right Frank this is controlled but due to the browser/net settings sometimes it takes a while to refresh the page and due to this User might click twice.

    But it happened to me without double-click while replying posts.

    Thanks Brad.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
    satya, Nov 25, 2003
    #2

  7. FrankKalis Moderator

    Computer can be very strange sometimes (<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<br /><br />Frank<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br /<a target="_blank" href=http://www.familienzirkus.de>http://www.familienzirkus.de</a>
    FrankKalis, Nov 25, 2003
    #2

  8. bradmcgehee New Member

    Flood control is activated, but I have a fairly high limit on this, and it won't affect most double-clicks as this (I don't think).

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
    bradmcgehee, Nov 25, 2003
    #2

  9. vbkenya New Member

    This can still happen without clicking the submit button twice. After posting the forum Server will sometimes throw an exception about the active timeout setting in IIS. Users will generally refresh the page or go back and try to post again and yes...a double post is made.

    The forum post counter is dead. I have been on the 405 posts mark the whole day after posting thrice. Are there new rules?

    Nathan H.O.
    Moderator
    SQL-Server-Performance.com
    vbkenya, Feb 11, 2004
    #2

  10. Luis Martin Moderator

    Last week I have a lot of problem whit duplicate post, mine and others.
    I've deleted 6 or 7 duplicate post in forum I can do that.
    No one was your, Nathan.


    Luis Martin
    Moderator
    SQL-Server-Performance.com
    Luis Martin, Feb 11, 2004
    #2

  11. bradmcgehee New Member

    Nothing has changes, except that the forum is getting busier. I will archive off some of the posts to hopefully speed up performance.

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

  12. satya Moderator

    Brad

    Yes, I could see the difference in the load on the forums and slow response as compared.
    Archive the old posts for better performance. Let me know if it can be performed within my privileges.


    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, Feb 18, 2004
    #2

  13. bradmcgehee New Member

    Only an administrator can archive.

    Also, there is a new version of the Snitz forum available. I will try to get it rolled out in the next week or so.

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

  14. satya Moderator

    I could see the archived posts for this forum and performance is better than earlier.

    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, Feb 19, 2004
    #2

  15. bradmcgehee New Member

    I still need to implement the new version of the forum software, but it may take awhile as I have to "re-customize" it.

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

  16. satya Moderator

    Brad

    It seems the trouble started again, I've deleted nearly 8 posts which are double-entries in the different forum sections.


    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, Mar 15, 2004
    #2

  17. gaurav_bindlish New Member

    Brad, the post reply link is terribly slow. Is there something I can help you with?

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
    gaurav_bindlish, Apr 20, 2004
    #2

  18. Argyle New Member

    When replying it seems it's only the redirect back to the post that takes long time (or the thank you page). If you post your reply and click on the main forum again your answer will already be there. This is the same when you get an ASP script timeout error after replying. You answer is already in the database but the redirect back (or thank you page) to your post fails and times out. So it looks like a forum or web server issue and not an SQL issue. That's just my opinion <img src='/community/emoticons/emotion-4.gif' alt=':p' />
    Argyle, Apr 20, 2004
    #2

  19. gaurav_bindlish New Member

    I have observed the same as well but the thing that bothers me is that duting the time the application slows down (after I hit the submit reply button), I can't open other posts as well and the other post comes only when the prevoius winow times out / shows the thank you screen.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
    gaurav_bindlish, Apr 20, 2004
    #2

  20. bradmcgehee New Member

    I have reindex the database, which may help some, but I am somewhat limited in what I can do. I have a new copy of the forum software, which I understand has some performance improvements. When I get time, I will add it. I will also archive some more posts.

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

  21. gaurav_bindlish New Member

    Thanks!

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
    gaurav_bindlish, Apr 20, 2004
    #2

  22. satya Moderator

    If you're using from the office PC due to the firewall and network limitations the [reply] page will take sometime to load as explained by Argyle.

    I always use Quick Reply section to reply the posts and when the page refreshes, click upon Active Topics to proceed for next topic. [a tip [8D]]

    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, Apr 20, 2004
    #2

  23. gaurav_bindlish New Member

    This is a valuable tip in understanding how can you post the answer so fast (even before I can see it [<img src='/community/emoticons/emotion-5.gif' alt=';)' />])<br /><br />Gaurav<br /><i>Moderator<br /><font size="1">Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard</i></font id="size1"><br /><font size="1">The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.</font id="size1">
    gaurav_bindlish, Apr 21, 2004
    #2

  24. satya Moderator

    Thanks Gaurav

    I use reply button occassionally and when I want to include any smiley's in the post, otherwise the above is my approach since beginning on this 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, Apr 21, 2004
    #2

  25. gaurav_bindlish New Member

    I have learnt the few smiley's and other formatting codes...

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
    gaurav_bindlish, Apr 22, 2004
    #2

  26. satya Moderator

    Hmm... lately I'm refreshing the shortcuts for the smileys... [<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 knowledge sharing.</font id="size1"></font id="teal"></center>
    satya, Apr 22, 2004
    #2

  27. Luis Martin Moderator

    I have to edit post when I want to add any smile. There is other way? ( not remenbering ctrl or something like that)

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
    Luis Martin, Apr 22, 2004
    #2

  28. gaurav_bindlish New Member

    There are shortcuts for the same. Just try to remember the symbol inserted in the post when you click on smily. e.g. [ <img src='/community/emoticons/emotion-1.gif' alt=':)' /> ] (without spaces) is for [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />Gaurav<br /><i>Moderator<br /><font size="1">Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard</i></font id="size1"><br /><font size="1">The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.</font id="size1">
    gaurav_bindlish, Apr 22, 2004
    #2

  29. satya Moderator

    [<img src='/community/emoticons/emotion-2.gif' alt=':D' />] another handy tip is when you're on the reply mode just take mouse pointer to the smiley and you can see the command shortcuts to be used. [<img src='/community/emoticons/emotion-11.gif' alt='8)' />]<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 knowledge sharing.</font id="size1"></font id="teal"></center>
    satya, Apr 23, 2004
    #2

  30. Luis Martin Moderator

    Well, I don't miss nothing then.
    If there a easy way under my nose and I don't see it, I image yours comments......[xx(]

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
    Luis Martin, Apr 23, 2004
    #2
Page 1 of 2

Share This Page