When selecting About from the hamburger 
menu the menu appears to be dismissed very slowly.
This is kinda two bugs / issues:
####Although the issue doesnāt look that bad on meta:
####But when you compare that to a site with a larger number of posts:
####Possible slow query
Iām willing to bet thereās no āpossibleā about it.
Iām wondering if āreal time - liveā stats are needed here.
Would it be that big of a deal if āall timeā and ā7 daysā were a bit off depending on the time the About page was looked at?
Personally, I donāt have a problem with the page load time, but maybe some kind of CRON could be used to get the stats āclose enoughā?
At least for the About. IMHO the Admin stats are viewed less frequently and by those more understanding so leaving them to be created āwhen calledā should be OK as is and have benefit the way they are.
The load time isnāt that much of an issue - itās the menu not dismissing that made me want to report itā¦
ā¦ it makes it āfeel brokenā.
True, it is nice to get visual confirmation that a click worked.
I would think it would be easy enough to remove the highlighting upon the click event, but maybe not.
@neil for this page, drop the deleted_at part of the query ā the total posts minus deletions is just going to be noise, how many can there possibly be? We donāt need that much accuracy here.
I am guessing
select count(*) from "posts"
will run plenty fast.
Could this be an indicator of other slowness?
Perhaps select is used elsewhere in combination with deleted_at = null.
I have reported many slow queries in the past that havenāt seen any developer action.
Iām just throwing it out there.
Possibly but rarely select *
Seems like there should be some logic to dismiss the dropdown on click instead of waiting for the page to load.
Actually, yeah, this is an indicator of a missing index.
The posts table has no index on deleted_at, and almost all queries against the table filter for that!
The index only improves it a bit, it still has to scan the entire index to get the count, data here should be cached at least for a few minutes, and the transition should be smoother.
Iām working on a fix right now for the dropdown not dismissing until the new page loads. Iāve provided two samples below, fadeOut('fast') and hide() respectively.
fadeOut('fast')
hide()Would love to get some thoughts on which to go with. 
fade out fast seems fine to me.
Just submitted a fix to dismiss dropdowns on click. Will look into about page issue soon.
Could I get a rough count of how many posts was on the site? Iām trying to reproduce the performance issue on development. Thanks 
Topics: 40.1K
Posts: 432.2K
Users: 10.2K
Private Message Topics: 101.0K
Patch landed on master. 
Both issue in this topic should be resolved.
As fast as lightning ! thanks heaps 
