core_url_rewrite database table and Magento Performance
I'm running Magento 188.8.131.52, and for the first time I truncated the database table "core_url_rewrite" after I came across some posts saying that this very table can become extremely large, while it requires manual database maintenance.
Indeed, after the table truncation and re-indexing, the size of the table reduced for almost 60%, and there was a significant performance gain when I tested my site with GTmetrix.
So, my question is whether there are other database tables (besides the ones related with Logging) which have impact on performance and require manual maintenance in the database.
Re: core_url_rewrite database table and Magento Performance
Yes, I'm aware of the tables related with logging. These tables are actually maintained by Magento, though I occasionally had to truncate some of them manually, as too old data had remained.
My concern is the tables that are affected by indexing process of Magento 1.x, such as "catalogsearch_fulltext" and "core_url_rewrite" tables. Are there any other indexing-related tables that need manual maintenance which can improve performance?