That is great news!

Thank you for bringing this issue to our attention, and reporting your results.

Since you reported this, I've observed several sites where the problem queries are taking quite a bit of resource to complete. None are extreme enough to grind to a halt, but obviously they are using way too much. Eventually, left unchanged, I'm sure they will run out of something and start failing. Xoops.org is one of those, and mamba does a good job of keeping us honest with the "eat our own dogfood" strategy -- most of the time, especially near releases, we are running the newest code from the head once it has passed local testing.

Next step, I'll use that 2.5.4 system I started up to test the upgrade for 2.5.11. Waste not, want not as my mother used to say.

Thanks again.

@geekwright

FYI; reverted to old db 300000K+ users, 100K never logged in. Your changes still work.

...B

Thanks, I had similar issues with users timing out (which was especially problematic when they're supposed to stay logged on for extended periods of time as Xoops is one of our working tools...), clearing the cached did the job!