We are having some issues with SysCache2 command dependencies timing
out -- e.g. one situation that takes around 40-60 seconds to SELECT
(table has 32 columns and 4 million rows).
To fix this I made a small addition to SysCache2 to allow an optional
custom commandTimeout.
<cacheRegion name="Tasks">
<dependencies>
<commands>
<add name="Task"
command="SELECT 1 FROM dbo.Task"
commandTimeout="120" <--- Hoorray
connectionName="Xyz" />
</commands>
</dependencies>
</cacheRegion>
Patch is here:
http://groups.google.com/group/nhcdevs/web/SysCache2CommandTimeout.patch
Thanks, Rich
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"NHibernate Contrib - Development Group" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com.ar/group/nhcdevs?hl=en
-~----------~----~----~----~------~----~------~--~---
