java, quartz and multiple tasks triggered at certain times saved in a database
<p>I'm building a system where users can set a future date(down to hours and minutes) in calendar. At that date a trigger is calling a certain task, unique for every user.</p>

<p>Every user can set a different date. The system will have 10k+ from the start and a user can create more than one trigger.</p>

<p>So assuming I have 10k users each user create on average 3 triggers => 30k triggers with 30k different dates.</p>

<p>All dates are saved in a database.</p>

<p>I'm new to quartz, can this be done in a more optimized way?</p>

<p>I was thinking about making a task run every minute that will get the tasks that will suppose to run in the next hour and remove them from database.</p>

<p>Do you have any better ideas? Did someone used quartz for a large number of triggers.</p>