完全相同的sql(sql sever profile 监控拿到的 ),代码中执行超时30秒,再数据库直接执行,秒出结果
执行sql如下,sql执行结果为0
select count(a.NodeId) as col_0_0_ from table1 a
where (a.NodeId in (select nodeactual1_.NodeId from table2 nodeactual1_
where nodeactual1_.ProcessId='0f9a7f99-4a54-497c-82eb-329bb76128d9'))
and a.ParticipantId='FFB0AC2D-C1B5-49E2-89B2-F4058523DF18'
报错如下图:
[图片]
背景:
金蝶的系统,没有源码
数据库:sql serve 08
orm框架:NHibernate