The data is not stored in database immediately rather takes hours to store

The data is not stored in database immediately rather takes hours to store. But when I restore the axon data and database back it works. I am using Axon framework with spring boot.

Hi,

Could you please share more details, so we could help you?
What do you use as database, and how do you know it takes hours to store?

Also what data takes long to store? The events from processing commands, the projection?

I am using MySQL database. Regarding the data, its from processing commands. Maybe its because of inconsistency between Axon data and the MySQL database. Sometimes, when I clear my whole axon data and set up a fresh database then it works. I can’t figure out what’s causing this ??

Not sure, maybe you need a refresh to see the data? I don’t know what you mean by inconsistency, as the Axon data is the data in MySQL if you use MySQL. Could you please explain?