is there any way to control the size of the database,i am using the domain from last 6 months with newpaper theme .currently database is 100MB and its growing further ..Can u suggest some way to control this
Database grows when you add new content, add new images, etc. Obviously using things like the 7 day popular stuff adds extra fields, so that could be avoided.
You can try using wp-optimize plugin to keep it optimized, and also if you have old plugins no longer being used which have left old tables and elements in the dbase you can certainly clean house on that. Plenty of tutorials online for cleaning up WP dbase.
Hi Charis,
Thanks for the reply ,.
i have many images where in i have one size added extra just to support one module …is there any way to get rid of that size and resize just the featured images so that we can decrease the size of the database as well
TollywoodFans
Well, the database does not store the image, just the info about the image.
So, typically it’s not huge overhead to have three sizes of images vs one size of image — since there still needs to be a data record OF the actual image someplace (otherwise the media manager would not work).
Often good idea to take a look at your dbase in something like phpMyAdmin, and read up on some of the online guides on cleaning house on your dbase for this kind of operation.
WP-Optimize really helps. I use it every day :_)
Thanks Chris…
that helped a lot …
I did some house cleaning on one of our bloated dbases, for a site that went live in Jan. 2006 using WordPress 2.0
— I’m actually migrating it “right now” on my other monitor to Newsmag 1.7.
Current dbase size : 189.1 MB (!)
So, I feel your pain 🙂
