• 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

digitalpoint

Well-known member
#1
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. :)

 

dutchbb

Well-known member
#3
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.
 

Adam Howard

Well-known member
#6
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. :)

This may help explain why people on lower end boxes or shared account, may have issues about timeouts when they check alerts.
 

Chris D

XenForo developer
Staff member
#12
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. :)

Shawn and I can't reproduce this any more, so we've decided to mutually blame his code. Everyone point your fingers at him! ;)