@bug99 I have 800K files (mp4) in my alerts folder and normally things work perfectly: I have 5 months of Continuous recording and 18 months of alerts video all in H.265 (I use Export to mp4 files). In the the BI UI and iOS app I see all the events. Excellent. The only problem is when I upgraded to 5.7.2.2, after 3 months of not upgrading, and BI disk size monitoring metrics got confused and said that I am over allocating 100%. I then decided to "Repair DB" but that took 6 days! Other than that, no problem.
I am thinking about switching to "Database only" and use all my disk space for "Continuous" recording. That will increase my Continuous recordings to 10 months and decrease my events to the same 10 months. Not as good as what I have now, but acceptable. The main benefit will be if it reduces the time to "Repair DB". Problem is, that like you I don't know if somewhere in there there will still be 800K small files that take for ever to "Repair DB".
The other option is to stop upgrading BI.
I am thinking about switching to "Database only" and use all my disk space for "Continuous" recording. That will increase my Continuous recordings to 10 months and decrease my events to the same 10 months. Not as good as what I have now, but acceptable. The main benefit will be if it reduces the time to "Repair DB". Problem is, that like you I don't know if somewhere in there there will still be 800K small files that take for ever to "Repair DB".
The other option is to stop upgrading BI.
Last edited: