0 Replies Latest reply on Jun 27, 2006 7:05 AM by Rasmus Aveskogh

    Database cleanup

    Rasmus Aveskogh Newbie


      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