IDataAccessAdapterParameterisedPrefetchPathThreshold Property |
Gets or sets 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 int ParameterisedPrefetchPathThreshold { get; set; }
Property ParameterisedPrefetchPathThreshold As Integer
Get
Set
Property Value
Type:
Int32Remarks Testing showed that values larger than 300 will be slower than a subquery.
Special thanks to Marcus Mac Innes (http://www.styledesign.biz) for this optimization code.
See Also