Anybody know what would happen long term if I changed BAS_IDGEN to BIGINT(19) (This in MySQL)
Also - I use a lot of Non Persistent objects o hold transient data, do these increment the IDGEN count?
Changing ID gen to BIGINT(19)
Changing ID gen to BIGINT(19)
Rocketman
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
Re: Changing ID gen to BIGINT(19)
In a test environment I did increase the size of BAS_IDGEN and also the size of the ID for my test BO. Everything worked good as long as the ID number was below whatever the current maximum is. But Aware must have an internal check to see if BAS_IDGEN is at the maximum. When I manually set BAS_IDGEN to 1 less then the current maximum and then tried to create a couple of new BO objects I got an error even though the new number would have fit in the ID with the increased size.rocketman wrote:Anybody know what would happen long term if I changed BAS_IDGEN to BIGINT(19) (This in MySQL)
Just guessing on this one, but I do not think Non Persistent objects increment the IDGEN count.rocketman wrote:Also - I use a lot of Non Persistent objects o hold transient data, do these increment the IDGEN count?
Bob
Re: Changing ID gen to BIGINT(19)
Hmmm Thanks Bob,
Does beg the question - what happens to our apps when we hit the max.
Support?
Does beg the question - what happens to our apps when we hit the max.
Support?
Rocketman
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
Re: Changing ID gen to BIGINT(19)
If you live that long until your sequence number got up to a Bajillion, then you could make it start down at a negative Bajillion - it will work its way back to zero in another 10 years
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
Re: Changing ID gen to BIGINT(19)
Yeah you're probably right. I think I mis-read my numbers just before I asked the question . I'm at 3 million out of a possible total of 2 billion (signed INT(11) ) after 9 years , so I guess it should outlive me
Rocketman
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
V8.7 Developer Edition. Server 2016 Standard edition. MySql 5.5
Re: Changing ID gen to BIGINT(19)
Jaymer,Jaymer wrote:If you live that long until your sequence number got up to a Bajillion, then you could make it start down at a negative Bajillion - it will work its way back to zero in another 10 years
Setting the sequence number to a negative number is an interesting idea, have you tested that?
Bob
Re: Changing ID gen to BIGINT(19)
Its not that I saw the sequence operate with negative #s, but I was fudging some IDs on some test data in SQL, and accidentally some went below 0.
System worked fine.
Aware & Kendo apparently didn't care.
System worked fine.
Aware & Kendo apparently didn't care.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL