Transient__redux_activation_redirect slow queries

[Pierre-GS]

Hi There,

I'm having an issue that is rising a lot of complaints and frustration for our user's customer and site speed test overall scored. We have a website store using Redux Framework onto www.Gotopress.ca. and really love it so far! For some reason, we keep having lots slowness generated from loading time of 3.65sc to 16.sc sometimes and or to the extent of having HTTP:// FTP Error (trying to upload just an 74kb image :/ You see the scenario). next, I will have a cord around my neck lol. I installed Query Monitor and I got a lot of slow queries (3-5 depending on the page) related to this:

UPDATE huberthwp_options
SET option_value = '1'
WHERE option_name = '_transient__redux_activation_redirect'
How can I solve this?

Our IT hosting work on this issue for about a week now, as well we let the theme developer know on this issue. Who of course told us "We can't edit or intervene it. We should wait for an update." & " I can see your problem but we can't intervene." Isn't it funny...

Anyway below is our Hosting IT and my replies with a hope we can fix this issue thank you very much for your time.

We re-optimised the database although it did not help with slow options table.

Moreover, we did more digging on the issue with transient__redux_activation, and found that it is mentioned by other users in their development forum as well (See link: ahmedkaludi/accelerated-mobile-pages#441 ) however there's no response from the Redux team. Unfortunately, at the moment we have tried all the optimizations that we provide, anything apart from this would require a dedicated developer to manually clear any redundant database entries and disable any functions. Woow!

I'm sure you guys can help me beyond this point, has i literally running out of options now.
You are the last hope!

Thx team!

[Pierre-GS]

http://support.redux.io/?id=nbpQmJQYGW8LQJu0JG9ERExHId5gxQaWMlUszlTIjcpyfNCgleWeSezEU4l10WmCHX%2FNi6%2FgFCXvWVjmtw1GCA%3D%3D

[kprovance]

For some reason, I thought I took that out a while back. It was for the upcoming beta and I forgot to update this code base too. I removed it in v.3.6.7.13, which you can download from this repo. You may have to self deploy. I have no idea when this will be updated at wp.org. Weeks, at best (not something I can do myself). Sorry about that. Hope this helps.

[Pierre-GS]

Thank you, Kevin! This worked like a charm! Yaay! :D 2017-11-27 17:32 GMT-08:00 Kevin Provance <notifications@github.com>:

…

Closed #3443 <#3443>. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#3443 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/Agdq5bOyAlZsIDHKbCZ-0SNprsjjC9ecks5s62KUgaJpZM4QsMpD> .

--

-- Regards, Pierre Ghesquiere. Confidentiality Warning: This message and any attachments are intended only for the use of the intended recipient(s), are confidential, and may be privileged. If you are not the intended recipient, you are hereby notified that any review, retransmission, conversion to hard copy, copying, circulation or other use of this message and any attachments is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, and delete this message and any attachments from your system. Information confidentielle: Le présent message, ainsi que tout fichier qui y est joint, est envoyé à l'intention exclusive de son ou de ses destinataires; il est de nature confidentielle et peut constituer une information privilégiée. Nous avertissons toute personne autre que le destinataire prévu que tout examen, réacheminement, impression, copie, distribution ou autre utilisation de ce message et de tout fichier qui y est joint est strictement interdit. Si vous n'êtes pas le destinataire prévu, veuillez en aviser immédiatement l'expéditeur par retour de courriel et supprimer ce message et tout document joint de votre système. Merci.