WP Database Optimize

You must delete the revisions (old versions of post)

Tune the tables.

Rebuild the indexes.

You can use plugins like

WP-Optimize – Cache, Clean, Compress

And the PHPMYadmin has the option in the bottom-center, just select all tables and then select optimize.

Experience: Since 2017 WordPress / Joomla
Website: https://wplecturer.com/
MSc Software Systems Technology (1991) BSc BA CIS (1989) Solaris 10 Admin 1 (2008) OCA DBA 11g (2011) Bio info: I started with WP in 2017, at the age of 55. I made this site in order to help others to learn it. My Web interests are WordPress, Joomla, Drupal, CodeIgniter, Gimp and, Moodle. I have worked as an Oracle...