MS-SQL Row Locking with relations leaves server cursors open

[Renato DeGasperis]

Hi Everyone,

 

I noticed this issue recently on ENV.DLL version 4.6 . Tables defined with AllowRowLocking=True and relations not specifying the relationtype.

 

In this case, ENV generates a MS SQL cursor for the table but the cursor never closes. Even worse is If I repeat the routine repeatedly, the application gets slower and slower forever, until I close the SQL session( the application in our case ). When I restart the application performance is back to normal for a while until the cycle repeats.

 

If I add a RelationType=OuterJoin ENV generates a LEFT OUTER JOIN rather than a cursor and all is happy.

 

I have ways to work around what looks like a bug in ENV that have additional benefits to avoid the problem, but I am wondering if anyone else has run across this issue, and/or if there is a fix in ENV that can be applied ?   

 

 

readonly SMCMP.Models.INQTYCNV_DBM INQTYCNV_DBM = new SMCMP.Models.INQTYCNV_DBM { AllowRowLocking = true };

 

 

Relations.Add(INQTYCNV_DBM, INQTYCNV_DBM.Convkey.IsEqualTo(POLINH_DBM.Convkey), INQTYCNV_DBM.SortByConvkey);

 

 

Thanks,

 

Renato DeGasperis

 

 

[Noam Honig]

Pease create a small reproduction using northwind and we’ll be happy to investigate it. 

Make sure to set cursor locking true, as is done in btrieve to all migration

Noam Honig  

Founder & CEO

www.fireflymigration.com

--
You received this message because you are subscribed to the Google Groups "Migrated By Firefly" group.
To unsubscribe from this group and stop receiving emails from it, send an email to migrated-by-fir...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/migrated-by-firefly/YT3PR01MB4963E5AD24E7894AE5DA78C0AB55A%40YT3PR01MB4963.CANPRD01.PROD.OUTLOOK.COM.