my database getting biger and biger
There are many possible reasons for that, but anything you upload does not go there. WP Clean UP is a plugin I use to clean and optimize my database, and there are times when I have no idea why it grows as it does.
https://wordpress.org/plugins/search.php?q=WP+Clean+Up
Hello Tuhin,
Wordpress stores more than just the posts on the database. Apart from storing user details, posts, post meta, etc. it also stores the revisions. So, the size of your db is likely to grow with time,
If you believe that your db is unreasonably large, you could use some plugin like WP Optimize.
Disclaimer: I haven’t actively used this plugin for a longer period and you need to be a bit careful about what you remove. I’d recommend you to take a backup of your db before proceeding.
I hope it helps.
~ Cheers!
it also stores the revisions
Ah yes, and you can control that and some other things a bit by adding something like this above “That’s all, stop editing!” in wp-config.php:
/**
** Various Dashboard Tweaks
* bridle 'AUTOSAVE_INTERVAL' */
define('AUTOSAVE_INTERVAL', 300 ); //seconds
/* limit 'WP_POST_REVISIONS' */
define( 'WP_POST_REVISIONS', 3 );
/* enable 'DISALLOW_FILE_EDIT' at Dashboard */
define('DISALLOW_FILE_EDIT', true);
