Is it worth it to clean MySQL from old records (DB 3.6 GB.)?

Question

MySQL

Now the site on Bitrix got to support. I found a lot of more unnecessary entries in the tables, I'm especially worried about the table with registered files (b_file) and the table with user baskets, incl. anonymous.
There are 16 million rows in a table with files, while in reality there are ~ 20,000 thousand files. And in the table with baskets ~ 3,500,000 rows, 80% are outdated and are useless ballast.
Question: is it worth bothering with a script to search for obsolete records? How does the number of rows affect fetch speed?

Answer 1

Garbage records - of course it is better to clean, the database will eat less memory. It should not directly affect the speed of the samples if the indexes are set normally and the requests go through them.
For such things, sometimes they create a separate database into which obsolete data is "poured". Bonuses: if you overwrite something important, then you can unload it back. If you need to build a report based on old data - here they are at hand.