1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Not a Bug 1,500 queries on a single request

Discussion in 'Resolved Bug Reports' started by digitalpoint, Jan 30, 2013.

  1. digitalpoint

    digitalpoint Well-Known Member

    It seems the AJAX request that generates the warning tab for a user doesn't consolidate queries by content type like search results do.

    We have a user with 1,483 warnings (hahaha)... mostly this is because they had a bunch of infractions per account, and then we merged a few hundred accounts together since they were all duplicates. But even so, we have users that have racked up over 200 infractions/warnings over the years without being a user merge.

    The end result of that particular user is nearly 1,500 queries running for that AJAX request... might be a good idea to consolidate by content type like search results. :)

    Alien, jadmperry, 0xym0r0n and 5 others like this.
  2. Dinh Thanh

    Dinh Thanh Well-Known Member

    That's interesting!
  3. dutchbb

    dutchbb Well-Known Member

    Oops. That's crazy though, after 7 red cards they're gone at our forums. But I understand the specific situation and your request is perfectly valid.
  4. HWS

    HWS Well-Known Member

    Valid and confirmed. :)

    Takes me to the question: How do you do a "user merge" with XenForo? ;)
  5. digitalpoint

    digitalpoint Well-Known Member

    It was from vBulletin user merge pre-migration.
  6. Adam Howard

    Adam Howard Well-Known Member

    This may help explain why people on lower end boxes or shared account, may have issues about timeouts when they check alerts.
    HWS likes this.
  7. Digital Doctor

    Digital Doctor Well-Known Member

    Three strikes and you're out ?

    3 strikes might be too little ... but 1,483 strikes is too much, IMO.

    Paginated warnings ?
    WOW !
    Shelley and 0xym0r0n like this.
  8. 0xym0r0n

    0xym0r0n Well-Known Member

    Can't help it....

    "If I told you once, I told you a 1000 times..."


    I love XFs discouraged user feature.
    Adam Howard and Shelley like this.
  9. Digital Doctor

    Digital Doctor Well-Known Member

    Sway, Devilwillcry4you and 0xym0r0n like this.
  10. Shelley

    Shelley Well-Known Member

  11. Mike

    Mike XenForo Developer Staff Member

    Shawn and I can't reproduce this any more, so we've decided to mutually blame his code. Everyone point your fingers at him! ;)
    Jeremy P, Jeremy, Kevin and 5 others like this.
  12. Chris D

    Chris D XenForo Developer Staff Member

  13. SchmitzIT

    SchmitzIT Well-Known Member

    Pereira likes this.
  14. Slavik

    Slavik XenForo Moderator Staff Member

    Boo Shawn sucks!
  15. erich37

    erich37 Well-Known Member

    Shawn is counting the queries manually ;)

Share This Page