When trying to install an extension, or performing the average database backup, I've realized i have less then 200 products in my catalog, yet the backup takes FOREVER. In fact, there is a database table 800 megabytes large, while the biggest one after that is only 16 megabytes.
What can i do with this to lighten up my database? Does this require a fresh new magento installation?
Having nearly 30 links for the one flyer page makes absolutely no sense. Why is magento doing this and how can i fix it?
Is magento creating a store for every store view? because i should have 3 stores (demo 1, demo2 and demo3) with about 8 or 9 languages each... However even with 200 products, the database is still HUGE. There are over 2,200,400 records in the url_rewrite table!