type of data ID in table "Frames" INT

Serg · Post by **Serg** » Mon Oct 10, 2005 2:07 pm

Today I have received so long expected (I waited for this case 1.5 years

) :

ERR [Can't insert frames: Duplicate entry ' 4294967295 ' for key1]

It was necessary to change type of data ID in table "Frames" INT on BIGINT.

Serg,
(ZoneMinder LiveCD 1.17.0 ..... 1.21.0)

Post by **zoneminder** » Mon Oct 10, 2005 9:02 pm

Yikes! I though it would be ages before anyone got to that! How big does a bigint go? 4G x 4G? I didn't make it this originally as I was worried it might be a bit slower than just native int size.

Phil

Serg · Post by **Serg** » Tue Oct 11, 2005 6:22 am

zoneminder wrote:Yikes! I though it would be ages before anyone got to that! How big does a bigint go? 4G x 4G? I didn't make it this originally as I was worried it might be a bit slower than just native int size.

Phil

INT (10) (from 0 up to 4294967295) - turn out a little for my configuration of system.
BIGINT (11) for the table "FRAMES" - I think it will be enough!

I worried too, whether this change will affect speed of work. But the system works also quickly as well as with type INT.

My system (works since March, 2004):
6 videocameras - 2 work in mode MODECT; 4 work in mode MONITOR in the afternoon, and at night they work in mode MODECT.

Whit many thanks to creators ZoneMinder è ZM LiveCD,

Serg (Russia, St.Petersburg)

Post by **zoneminder** » Tue Oct 11, 2005 4:01 pm

So that's just double then. You've only got another 1.5 years left!

Phil