Performance Question
-
So I have been using this plugin for a while now and it works great, but I do have a performance question.
From looking at the DB, it appears all of the custom sidebar widgets that are text widgets are stored in one cell.
Currently, my site has ~130 pages and I have different content in the sidebar on almost every page with text widgets. So with ~4 widgets per page, I am using ~500 custom text widgets. I like to be able to control these at the page level for optimal internal linking.
I notice when I load the custom sidebars page in the admin, it takes a little while to load. The site seems to load fine, but I was wondering what happens if I create a site with 300 pages and 1200 custom text sidebar widgets?
To reduce the amount of actual text data being stored in the DB, for widgets that I reuse on several pages, I actually created a short-code that contains the text. This also allows me to update the content in one place and have it roll out across the site.
(When I set this up, the feature to clone widgets was not available. I found another plugin to clone widgets, but was worried they might eventually run into compatibility issues, so the shortcode method seemed to work better)
I also run other short codes like page-list in these widgets.
Just wondering if you foresee any performance issues with having too many text widgets in the DB?
The topic ‘Performance Question’ is closed to new replies.