This setting creates stored procedures for completing single-record record deletes at the SQL database. If you don't include this setting in the defaults file, no stored procedures will be created. Using auto-generated stored procedures at the SQL database will typically improve the performance of database delete operations.
SQLDisableSPForDeletes=option
• option - A boolean indicating one of the following:
![[spacer]](1p.gif){kind=small}
|
Value |
Description |
|---|---|
|
TRUE |
Stored procedures won’t be created when a new table is created. |
|
FALSE |
Stored procedures will be created when the table is created. The database will use these stored procedures when completing single-record delete operations. |
If you add this setting and set it to FALSE, creating a new table in Dexterity will also create stored procedures for single-record deletes at the SQL database. All existing tables will continue to complete single-record delete operations without stored procedures.