DaoBaseParameterisedPrefetchPathThreshold Field |
The parameterised prefetch path threshold. This threshold is used to determine when the prefetch path logic should switch to a
subquery or when it should use a WHERE field IN (value1, value2, ... valueN) construct, based on the # of elements in the parent collection.
If that # of elements exceeds this threshold, a subquery is constructed, otherwise field IN (value1, value2, ...) construct is used.
The default value is 50. On average, this is faster than using a subquery which returns 50 elements. Use this to tune prefetch path fetch logic
for your particular needs.
This threshold is also used to determine if paging is possible. A page size bigger than this threshold will disable the paging functionality
when using paging + prefetch paths.
Namespace:
SD.LLBLGen.Pro.ORMSupportClasses
Assembly:
SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.4.0.0 (5.4.0)
Syntax public static int ParameterisedPrefetchPathThreshold
Public Shared ParameterisedPrefetchPathThreshold As Integer
Field Value
Type:
Int32Remarks Testing showed that values larger than 300 will be slower than a subquery. This setting is a global setting, so will affect all
database actions after setting it to a new value.
Special thanks to Marcus Mac Innes (http://www.styledesign.biz) for this optimization code.
See Also