Serial Number Performance and DB Locking

[Former Member]

Hi All,

Can anyone assist with an issue we are having with our SBO2007 PL 42...

There are 8 million Serial Numbers in the system with an average of 1 million Serial Numbers per Item (8 Items). - Table OSRI

There are 40 milion Transactions in the system with and aveage of 5 Transactions per Serial Number.

When the Serial Number Selection Screen opens in a Marketing Document, it slows the entire organisation down and it seems like there are Locks in the Database that are causing this.

Can anyone help me understand why this occurs and if there is any way of overcomming this "Serious" Issue?

Thanks.

[Former Member]

Hi,

Please close your duplicated thread.

Thanks,

Gordon

[Former Member]

Closing of Duplicate Post.