BI database size, what's too big?

M

marklyn

Pulling my weight
Jun 13, 2015
470
108
My Blue Iris clips database is around 16gb in size... is there a point where this could be a problem?
I don't seem to be having any issues but that does seem very large.
It sits on a SSD drive and there is plenty of space on the drive for it to grow.
 
database size is primarily based upon the number of cameras, the number of clips saved per camera, and for what duration the clips are saved.

if you BI system has been running for at least "duration" (days, hours) and the database size is relatively stable, it is what it is. However, if you database continues to grow and grow and grow you may have inadvertently disabled the compression/compaction of the database.

check Settings, Clips and Archive, Database and make sure you have "Compact/Repair DB" enabled with one or more days highlighted.

1581108372336.png
 
  • Like
Reactions: marklyn
It was set as shown. Thanks
 
MY data base folder is 1.1 GB. I have 13 actual cameras and 10 clone cameras. Do contiguous recording each clip is 1 hour and I keep about 22 days of data.

Try deleting the data base and restart BI, it should rebuild it.
 
I have 12 cams, no clone cameras. All are motion triggers and I have about 4 months and 2 weeks of clip storage (using a 4Tb Drive). Looks like I have about 123K of clips.
 
bp2008 said:
It is a shame Blue Iris doesn't use an actual database engine. Whenever it is repairing the DB, it can't record anything new.
Click to expand...
Did not know that... maybe I should turn my rebuild/compact on 3 times a week instead of every night @ 2am.
 
So your size is about correct. I have about 12K clips and 1.1 GB size. If the info as to what is in the DB is correct. I have never really look at the size until today.
 
Just wanted to toss something out there about clip storage size. I'm still a little lost on performance improvements upon the BI computer and options other than following the how to optimize BI. I will say this: I bumped my cam number upto 14. CPU was well over 50-60% most of the time. I did SouthernYankee's suggestion to bump clips down to 1 hour and now my CPU hovers under 40%. That's 2 x 8MP, 4 x 4MP, 8 x 2MP cams with a total bit stream of a little over 6000 kB/s. Somehow, made a HUGE difference.
 
  • Like
Reactions: looney2ns
You must log in or register to reply here.
Top Bottom