[
https://issues.apache.org/jira/browse/IBATISNET-18?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gilles Bayon closed IBATISNET-18.
---------------------------------
Resolution: Won't Fix
Assignee: Gilles Bayon
> Improve execution of SqlCommand text
> ------------------------------------
>
> Key: IBATISNET-18
> URL: https://issues.apache.org/jira/browse/IBATISNET-18
> Project: iBatis for .NET
> Issue Type: Improvement
> Environment: Data Mapper
> Reporter: Gilles Bayon
> Assignee: 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.
-
You can reply to this email to add a comment to the issue online.
