WordPress should REMOVE Plugins (Themes may be) DB record after deletion

[talha-presstigers]

Hi,
I am a WordPress developer and front-end designer. I used WordPress for work. It's been almost 3 years that I am developing WordPress sites with WordPress Themes & Plugins development.
In WordPress we face the issue of speed when the WordPress site got heavy traffic. This is because there are garbage values in the DB and some of them are loaded on the front-end without any reason.
I give you an example for that.
I installed a plugin name "ANY Plugin Name", the "ANY Plugin Name" create some options entries in the wp_options table with auto-load = yes, then I uninstalled and delete the "ANY Plugin Name" plugin but the plugin did not remove its DB record like auto-load options values.
Now whenever the user visits the site the "ANY Plugin Name" plugin auto-load options are loaded without any reason and that cause the speed of WordPress site.

The new feature request for this task is that:

1. WordPress should keep an eye on plugins db queries record.
2. When deleting the plugins, there should be an other options like "Yes, delete plugins files & DB records"
3. So , in this user can also delete the plugins DB records that act as a garbage value for WordPress after plugin delete.
4. I am attaching an image URL for this presentation

Thanks & Regards,
Mohammad Talha
WordPress Theme & Plugin Developer

[talha-presstigers]

The file presents the new option when deleting a plugin from WordPress.

[swissspidy]

Hey there, thanks for your report!

I know that unneeded database tables or entries can be annoying and slowing down things, but it's impossible for WordPress to automatically know what records a plugin creates in the database.

That's why plugins are encouraged to register an ​uninstall hook to remove any data upon plugin deletion themselves.

If a plugin properly does that, a button like you described in your screenshot is automatically added. If a plugin doesn't implement this, you should really talk to its developer.

See also #20578 for UX improvements for the uninstall process.

[talha-presstigers]

Okay I understood.

Thanks for your quick response.

Thanks & Regards
Mohammad Talha