Trying to Identify Query that Causes Slow DB Running

[Banana]

Hi

It has been identified that the following query is being run frequently on our database causing it to run very slowly when load is higher than normal


SELECT COUNT(*)...

[Banana]

Does vb accept IP addresses in that format? If so, it should ! ...

[Banana]

This was asked 4 years ago and not answered

What is the thinking behind randomising the User Activity stats when the "rebuild stats" option is selected?

I know...

[Banana]

This still happens in 3.7

Why does it need to change the data to obviously incorrect numbers. If the function cannot provide correct numbers then it should leave the data alone!

[Banana]

What is vbulletin doing about adhering to this impositions from hotmail, yahoo and aol given that Alfa one suggests that using VB "as is" is in contravention of them?

[Banana]

Turned on TT and some other settings, I can't even read it now

Thanks for the tips

[Banana]

I've started getting these over the past few weeks - sometimes 10s a day. And image verification has been on for months if not years.

[Banana]

It's a code change then..... just wanted to make sure I didn't miss an option.

[Banana]

My calendar only offer times :00 and :30 from the drop down. I need :15 and :45 too. Is this configurable or is it a code change?

[Banana]

Is this fixed as per Scott's comments in 3.0.3?

[Banana]

OK. But where is the default value of 40 held?

[Banana]

Here's what my FORUMHOME template says

  <a href="online.php?$session[sessionurl]">$vbphrase[currently_active_users]</a>: 

I don't see the "online.php?perpage=40"...

[Banana]

The Who's Online has some defaults:
user agents: No
per page: 40

where may I change these defaults?

[Banana]

Invisible members are visible to administrators when they are online (and their last visit in available in the adminco too) so I don't quite understand why this would be done "on purpose"....

[Banana]

Still happening for invisible members - doesn't even list me!

[Banana]

looks good

[Banana]

It does. Thanks....

[Banana]

Take 1 case
Last Visit in Admin CP for user: 15 June 17:01
In Members List this column is blank.
However they are "invisible".

[Banana]

Yes they have, lots of times.

[Banana]

No. upgraded from 2.2.8 to 3.0.1