What would be the best way to implement a database cleanup routine where old orders, logs, variables etc. are deleted? Going through Hibernate or deleting in the database right off?
Currently I have ~80000 orders with ~6000000 logs and ~500000 variables and the performance is definitely affected.
Are there any performace benchmarks related to these entities? I realize that many factors affect the performance, for example which database backend one is using, but it would be interesting to know where the definite limit is.
(I use PostgreSQL)
-ra