• Resolved Mark

    (@markob17)


    Hi,

    Thanks for creating this and your other plugins. Noticed they have received positive praise. I’m a noob when it comes to database stuff and have a few questions before I install this.

    • Are there any risks that I need to be aware about?
    • Does this increase the size of the database?
    • If I uninstall the plugin, will it remove the database entries it ads?

    If there is anything else you think I should know before installing your plugin, I am all ears!

    Regards,

    Mark

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author OllieJones

    (@olliejones)

    Thanks for the good questions!

    Risks: in the almost two years since first release, I haven’t heard of anything disastrous. You might check the negative reviews: they seem to be related to confusion about how to configure things, rather than defects in the plugin. I do ask you to make a backup first.

    Size increase: yes, keys take SSD / HDD space. It doesn’t change the number of items in the database, only the size of the data structures. I think it’s about 25%, but that’s (a) hard to measure and (b) different on different sites.

    Uninstall: Please read this. If you want the keys reverted to WordPress standard, you have to do that before deactivating or uninstalling the plugin. At any rate, it doesn’t add entries to the database, only data structures.

    Thread Starter Mark

    (@markob17)

    Thanks for the detailed reply. I decided to try the plugin and the site I used it on was super slow. Site has 75,000 posts. I installed a bunch of other stuff like page caching and Redis too, cloudflare Super Cache, delayed java, etc., but before this, QueryMonitor showed the database was having huge issues with speed. I cleaned up autoloads in options table too (was quite large). Moving tables to Innodb per your plugin setup was also done of course. There is still something a bit off with this site (has been moved to different hosts many times and is poorly managed among other things), so maybe corruption, or maybe the server is just not good enough for this big a site. IDK, but after doing all this and installing your plugin, this site feels incredibly fast now. IDk. Maybe your plugin was the icing on the cake for all the other stuff I’ve done. The next step is getting this site moved from the Theme it’s one to a more efficient theme. The slow database calls seem to be originating from the theme (used QueryMonitor). Either way, am happy to report this plugin is working fine on a fairly large site, and the site is actually usable again. Pageload literally went from 15 seconds to 475 ms. When logged into backend, it’s also much faster, but still a bit slow during some actions. I’m suspecting something is off with this theme, but not sure entirely.

    Plugin Author OllieJones

    (@olliejones)

    Delighted to hear your MySQL / MariaDB server is working more efficiently now! This plus a good persistent object cache will help speed up your “back-end” — the part of your site that searches, retrieves, filters, and renders your content. Cloudflare and page caches are good because they speed up your “front-end” — the delivery of your content to your audience.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Pre Use Questions’ is closed to new replies.