That's just what SqlCommand uses. See:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm l/cpconsidebysideexecutionadonet.asp (or use http://tinyurl.com/4gclc if that URL gets broken up by your mail reader) Hope this helps. Roberto -----Original Message----- From: Alexey Boroday [mailto:[EMAIL PROTECTED] Sent: Thursday, December 30, 2004 5:23 AM To: ibatis-user-cs@incubator.apache.org Subject: MS SQL slow query performance Hello. I use "SqlServer 1.1" provider and have noticied that all queries from my application are wrapped into exec sp_executesql commands Such queries work very slow :( comparing to the plain-text queries from the query analyzer (ten or even more times). Could you help me please - is there any possibillity to make iBATIS pass to the server plain-text queries where parameters are replaced by its values? Or pass query with parameters but without "sp_executesql" procedure? Where should I look to change iBATIS sources to obtain such feature? I could try to write all code that is required and post it (diff) here for all. -- Thank you. ___________________________________________________________________________ This communication is confidential and may be legally privileged. If you believe you are not an intended recipient, please inform the sender, delete the e-mail and do not copy, print or use it or disclose it to others. You can inform the sender by replying to this e-mail or by telephone (+380 44 4906080).
