My database is growing to fast, i am updating every night 30.000 items, so the "item history" table AITM is getting bigger and bigger (about 6Mio rows now).
BTW: Are there any other history tables for items which i don't need?
Do i need this table or can i delete the data? We have problems to update SBO with a database which is about 20 GB in size.
There are may reports for inventory as well as other aspects of the system that point to the AITM table and as you may have noticed there is no "purge" option to remove records from these tables, which would be the appropriate method of removing data from these tables as there is a cascade effect with other tables. I would not recommend removing item rows from the history tables via SQL as that will cause errors when running reports that depend on these tables as well as other system queries.