Activating the WP Data Access plugin causes a dramatic performance hit to the website. Deactivating it instantly speeds up site loading speeds. Currently using the free version, want to use the paid version, but cannot if it slows the site down this much. I have left the plugin enabled at this time so you can see the slow speed.
I have tested this plugin several times with and without other plugins enabled and always results in the same manner. It is possible that the hosting package we are using simply cannot handle the data processing the plugin uses, but I wanted to verify that here first. I just thought it was odd that the plugin would effect the loading of every page frontend and backend of the site just for being active, but I do not know enough of how it works to understand why it does.
The website is hosted by Bluehost and below is the server information:
Hosting Package Platinum Pak
cPanel Version 102.0 (build 26)
Apache Version 2.4.55
PHP Version 8.1.14
MySQL Version 5.7.23-23
Architecture x86_64
Operating System linux
Shared IP Address ***.***.***.**
Path to Sendmail /usr/sbin/sendmail
Path to Perl /usr/bin/perl
Perl Version 5.16.3
Kernel Version 4.19.150-76.ELK.el7.x86_64
The page I need help with: [log in to see the link]
Sorry to hear you’ve encountered issues when the plugin is active.
We ran your site using PageSpeed Insights and indeed the results show that it’s currently very slow, however the top “culprits” seem to be the images as well as the embedded video player.
The youtube part was the default gutenberg editor youtube block. I have replaced it with a plugin just now that is more optimized.
However, I did a test and disabled all plugins. I was able to navigate the site and the backend of word press just fine.
I enabled WP Data Access and the site immediately slowed down, and I do not just mean the front end, this is including trying to navigate the backend of wordpress to pages, posts, plugins, etc. Doing a search to add a plugin or trying to change a parent page for a page results in long load times.
My only thought is it relates to bluehost performance issues, maybe the wordpress gutenberg editor, or perhaps because WP Data Access sees all of our databases and not just the WP tables. It could be possible our database is bloated I guess.
Note: I am leaving it disabled for now as I need to work on the site more and it slows things down too much for me to do work.
This reply was modified 3 years, 3 months ago by justinkennedy.
This reply was modified 3 years, 3 months ago by justinkennedy.
I talked to Bluehost and they made some tweaks they stated, but the issue seems to still exist.
I also added the Query Monitor plug-in and it shared these results with me.
I have tried searching why this would be causing slow performance, but I could not find anything obvious. This single query though appears at least running slow on every page I visit, and sometimes as in the image above it appears more than once.
Sometimes it is really bad as seen here:
Went back and clicked the + next to some so here is more details:
This reply was modified 3 years, 3 months ago by justinkennedy.
I included in there, but will state it here as well. I did a fresh wordpress install with the only plug-in being WP Data Access. The performance issues still existed. I then installed the query monitor plugin and it displayed the same issue with the slow query shown in above images with page load delays ranging from 2-9 seconds.
This reply was modified 3 years, 3 months ago by justinkennedy.