When is a Wordpress database too large?

[BuildMyWeb]

Have a client who has a Wordpress site that is running slowly and wants performance improved.  It is averaging on the order of 7 seconds or so to render basic pages.  No video, few images, etc.  The database has about 1 million records.  my primary question is, "When does Wordpress hit a point that the db is too large and will slow down a site?"  i understand there is no definitive answer, just trying to get a ballpark.  its noteworthy that about 700,000 of those records are in a table for the REDIRECTION plugin.  ive deactivated that plugin to eliminate those records as a factor.

 

 

as an fyi to anyone with any other ideas on how to speed the site up

- ive deactivated all plugins with no effect

- activated Twentyfourteen theme with no improvement ( to eliminate theme issues )

- uploaded a php page outside of Wordpress and it rendered immediately.

 

[QuickOldCar]

As far as mysql is concerned a million records isn't too many as long as properly indexed.

 

Maybe the hosting is just sucky.

The only way to run a good wordpress site is on a dedicated server, anything else and it's just getting by.

 

I've dealt with wordpress since the beginning, it was never really fast beyond a vanilla install.

 

Their numerous queries to mysql are horrible.

 

Do you have any caching? If not load wp super cache to render html pages

 

P3 plugin performance profiler is a handy plugin

 

Try some page loading tests at Pingdom to see any missing or slow files

 

Any of those fancy image sliders loading many huge images?

Try a lazy image loader.

 

If you have a link to the site I would take a look.