| Upgrade Guides for Genero BDL / 3.00 upgrade guide | |
The SERIAL and BIGSERIAL types can be emulated with triggers and sequences when using SQL Server 2012 and higher.
By default when using SQL Server, the SERIAL and BIGSERIAL types are emulated with IDENTITY columns. This native sequence generator is the fastest and prefered solution. However, it requires to remove the serial column in all INSERT statements, which can lead to a large change in your legacy code.
Until version 3.00, you could workaround this limitation by using the "regtable" serial emulation. But this solution is using a dedicated SERIALREG table that must be updated for each INSERT statement. This can result in bad performances, when concurrent programs create rows in the same tables (locking issues in SERIALREG).
Starting with Genero 3.00, it is now possible to use a serial emulation based on triggers and sequences. Sequences where introduced in SQL Server version 2012, so you need at least a 2012 server in order to use this emulation:
dbi.database.mydb.ifxemul.datatype.serial.emulation = "trigseq"