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 View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3953674#3953674 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3953674 Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
