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
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
