version 3.1
Mysql

Hey,

I need to delete big amount of data (around 300K records).
I don’t want that the delete process will disturb to the main process (event record) to run.

I am going to delete the records with hql statement (is it good, is there any impcat that i need to consider)

My questions:
1. Is there an option to delete in chunks?
2. Is there a way to delete in background?
Can I check if the process or the db is busy and in case it is to wait with the delete?

Do you have any tips for this?

Thank you.

As far as I know there is no (build in) option to delete in chunks or in background. So you have to split you're data and write a thread on you're own. After all hibernate is an OR framework not a framework for batch processing.