Skip to main content

Posts

Showing posts with the label number sequences

What can go wrong with number sequences?

Very low performance of the application Data base blocking on the number sequence table so al user get stocked when the need a sequence number. Let’s start with the worst performance setup related to a number sequence. We set the customer account number on continues. The below table shows the queries that are executed. Continues = true, pre allocation = false First time (8 database calls) SQL statement: (SysRecordTemplateTable) SQL statement: (CustFormletterParameters) SQL statement: (NumberSequenceReference) SQL statement: (NumberSequenceTable) SQL statement: (NumberSequenceTable) SQL statement: (NumberSequenceList) SQL statement: (NumberSequenceList) SQL statement: (NumberSequenceTable) Second time (5 database calls) SQL statement: (NumberSequenceTable) SQL statement: (NumberSequenceTable) SQL statement: (NumberSequenceList) SQL statement: (NumberSequenceList) SQL statement: (NumberSequenceTable ) Now we remove the Continues option and create a new custom...