SubJunk
SubJunk
I ran these commands and it has cleaned up those bottom 3 entries: ``` ALTER TABLE kAJw62_albums ADD INDEX albums_parentid (parentid); ALTER TABLE kAJw62_albums ADD INDEX albums_dynamic_parentid (`dynamic`, `parentid`); ALTER...
The logging shows that the top query took 2136 seconds in total, I only enabled logging for a few minutes. That's very slow in my opinion. Looking forward to seeing...
Thanks for your work on it, I will test this when I get a chance and let you know
Just letting you know I didn't forget about this, I am just very time-poor lately :) will do it ASAP
I'm not sure whether there is more needed, but here is a start for the indexes https://github.com/zenphoto/zenphoto/pull/1485
My websites are finally using the latest zenphoto code 🎉 But the performance is much worse with the new version vs the old version. The average load time of the...
Thanks for looking into it, I really appreciate your time and expertise. > I am a bit surprised because as actually the whole gallery/image handling didn't change at all. Are...
I did the profiling and although there are some unindexed queries they do not seem to be the problem, the slowest one is still only taking `0.08s` each time. So...
Here's the kcachegrind analysis for one php process, with the sorting applied to show the most expensive functions at the top. We can see here that `array_search` is taking up...
@esabol I agree and have edited the issue to match what you said