[ http://issues.apache.org/jira/browse/IBATISNET-18?page=comments#action_12330482 ]
Jeremy Gray commented on IBATISNET-18: -------------------------------------- I'm aligned with Hugo: Any single-execution performance improvement that could come from such a change, and in any case I doubt much if any improvement would occur, the security and cache pollution issues are too great to ignore in favor of a small-if-any performance gain. This issue should be closed as Won't Fix. > Improve execution of SqlCommand text > ------------------------------------ > > Key: IBATISNET-18 > URL: http://issues.apache.org/jira/browse/IBATISNET-18 > Project: iBatis for .NET > Type: Improvement > Environment: Data Mapper > Reporter: Gilles Bayon > Priority: Minor > > Idea from Alexey Boroday > Hello > I see that SqlCommand executes commands with parameters with sp_execsql. > But it is too slow. > My proposition is parse CommandText and replace parameter names with > parameter values inside CommandText e.g. > Lets say we have command > delete from Table1 where id = @id > so this cammand will be passed to the server as > exec sp_executesql N'delete from Table1 where id = @P1 ', N'@P1 > nvarchar(2)', N'5' > This command performance isn't very differs from the plain text command. > But for complex select query performance very much slow. The same query > without parameters works faster. > I'd like to propose inside iBATIS (somewhere, I cann't still find where) > parse command text and replace params via their values in the CommandText. > After that into the server will be posted query like this: > delete from Table1 where id = 5 > May I try to implement such behaviour as an option? > Happy New Year. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
