Forum Replies Created
-
AuthorPosts
-
August 13, 2015 at 8:22 am in reply to: 500 server error / Options table filled with data from plugin #995783KennyParticipant
Thank you for those resources. I did remove them manually using SQL, but I will check out those plugins if it becomes an issue again.
KennyParticipantWe are also experiencing this same problem. Please see our screencast for a detailed demo of what’s happening. This was not happing prior to the last update. https://youtu.be/0auqA1Oe9Io
KennyParticipantThanks Nico! It is working better. Turns out that half the delay was being caused by something else on our page. We didn’t see that until this new version. The page load went from about 25 seconds down to around 12, and after I removed some code that was making a call to an outside api, the page now loads in about 2.5 seconds.
@Adam – thanks for the guidance on changing the mouseover data. I don’t think we’ll need to do it now that the page is loading fast enough now. It’s better to have more info if we can. Plus, just removing it from the display wouldn’t thin out the query, which is what I was suggesting to Niko – an option to only get the title and link, so less time would be spent in the query. Perhaps he can add that option in later, combined with the code you suggested, so that we could choose to remove the display data, and thin the query at the same time. :o)Kenny
KennyParticipantNico,
I have tried going all the way back to 3.9.1, the earliest you offer, and it hasn’t changed a thing.
I think the issue is that you are loading all the events, plus the images, for the mouseover on each and every event on the monthly calendar. I looked for a way to disable this in the admin, but there doesn’t appear to be a way.
If your code is getting all that data from the sql server in one fat monolithic query, that would definitely not scale well. However, without knowing more, all I can offer is a best guess.
Can you tell me if there is a way that I can disable the mouseover effect in month view so it won’t try to retrieve anything more than the title and link? Is that the fix you’re working on?
Kenny
KennyParticipantNico,
Thanks for the speedy reply. I didn’t even realize you replied till today. :o)
I turned on the caching for month view, and it didn’t have any effect.
I can download 3.9.3 and try that one, but I’d like to make sure that I won’t lose any data when replacing the files with the older version. Can you please confirm this for me?
Kenny
KennyParticipantWe are also experiencing very slow performance related to this bug. Our new site is due to launch in the first week of July, so we are anxously awaiting the patch.
Kenny
-
AuthorPosts