Not a bug 1,500 queries on a single request

[digitalpoint]

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.

 

[agison]

That's interesting!

 

[dutchbb]

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.

 

[HWS]

Valid and confirmed.

Takes me to the question: How do you do a "user merge" with XenForo?

 

[digitalpoint]

It was from vBulletin user merge pre-migration.

 

[Adam Howard]

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.

 

[Digital Doctor]

We have a user with 1,483 warnings (hahaha)...we have users that have racked up over 200 infractions/warnings over the years

Three strikes and you're out ?

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

Paginated warnings ?
WOW !

 

[0xym0r0n]

Can't help it....


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

literally....

I love XFs discouraged user feature.

 

[Digital Doctor]

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

literally....

bahahaha

 

[Shelley]

bahahaha
View attachment 39907

.lol:hover

 

[Mike]

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

 

[Chris D]

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!

 

[SchmitzIT]

SHAWN IS A NOOB!

 

[Slavik]

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

Boo Shawn sucks!

 

[erich37]

Shawn is counting the queries manually