This setting creates stored procedures for completing single-record read operations at a 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 read operations.
SQLDisableSPForSelects=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 read 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 reads at the SQL database. All existing tables will continue to complete single-record read operations without stored procedures.