I tried a few different things which though work well but needs atleast few minutes of downtime so I am coming to my favorite place to seek opinion.
We have a gaming website which is open 24*7. The data in the tables grow rapidly. The problem is that when I try to delete the data, it does work and in 15 minutes or so, I can delete the data accumulated for over 24 hours but this does hamper transactions and because delete locks down the table, this process although working well does not suit my current requirements. A senior developer tried deleting row by row so that only rowlocks are taken but that is not purging data fast.
If somebody has worked in such an environment before, please give your suggestions and inputs on how to take this further.