I have a problem with big tables and MS SQL Server. The table has more than 5 million records. Select and Update statements are very slow. I think the problem is the statement with parameters generated by ojb. The statement with the parameter syntax runs almost 6 seconds, without it just takes mills.
Has someone also recognized is problem. Does someone knows why this syntax is so slow and has some suggestions how to fix it. Is there an easy way to change the statement generation, if there are no other advices. Example First takes 6 sec exec sp_executesql N'UPDATE History SET [EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],hisLastModifier [EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],hisAttac [EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED] 11 WHERE hisOID = @P12 ', N'@P1 datetime ,@P2 nvarchar(4000) ,@P3 datetime ,@P4 nvarchar(4000) ,@P5 nvarchar(4000) ,@P6 nvarchar(4000) ,@P7 datetime ,@P8 nvarchar(4000) ,@P9 nvarchar(4000) ,@P10 nvarchar(4000) ,@P11 nvarchar(4000) ,@P12 nvarchar(4000) ', 'Jul 28 2003 5:17:32:000PM', N'ibrahimk', 'Okt 20 2003 5:29:29:777PM', N'SYSTEM', N'SV: xxx', N'', 'Jul 28 2003 5:17:31:000PM', NULL, N'90', N'1080', N'5CCFCCE8-B144-11D7-A860-0007E90F2D57', N'FC7C1593-9D39-4D21-9E02-B86F91DCCDD7' Second takes just mills exec sp_executesql N'UPDATE History SET hisLockTimestamp=''Jul 28 2003 5:17:31:000PM'',hisLockUser=''ibrahimk'',hisLastModified=''Jul 28 2003 5:17:31:000PM'',hisLastModifier=''SYSTEM'',hisShortDescription=''SV: xxx'',hisDescription='''',hisCreation=''Jul 28 2003 5:17:31:000PM'',hisAttachmentOID='''',hisOrderStatusOID=''90'',hisHistor yTypeOID=''1080'',hisOrderOID=''5CCFCCE8-B144-11D7-A860-0007E90F2D57'' WHERE hisOID = ''FC7C1593-9D39-4D21-9E02-B86F91DCCDD7''' with kind regards Markus Denkinger ARMAX mindware GmbH Bernh�user Strasse 3 70771 Leinfelden-Echterdingen Fon: 0711 7823996-13 Fax: 0711 7823996-63 [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
