As a result, the select Query with uid and timestamp at the where criteria, use no index.
Severe performance issues, especially when having many users. I can see the query at mysql slow log many times per second.
Also I have noticed that PK creation is commented at drupalchat.install script.
Please advise. Thank you

CommentFileSizeAuthor
#3 drupalchat_init-slow-performance.jpg18.76 KBsocialnicheguru

Comments

darklrd’s picture

darklrd commented

Did you research this further? What happens if you un-comment that line and re-install? Thanks.

socialnicheguru’s picture

socialnicheguru commented

I am seeing that drupalchat_init is taking a long time to execute even with nodejs enabled.

socialnicheguru’s picture

socialnicheguru commented
StatusFileSize
new drupalchat_init-slow-performance.jpg18.76 KB

Here is my output from devel

darklrd’s picture

darklrd commented

Which version are you using? Is it 7.x-1.0-beta11? Thanks.

socialnicheguru’s picture

socialnicheguru commented
Version: 7.x-1.0-beta11 » 7.x-1.0-beta16

I am using beta16

darklrd’s picture

darklrd commented
Version: 7.x-1.0-beta16 » 7.x-1.0-beta20
Status: Active » Fixed

It was commented out accidentally. Fixed in the latest release.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.