ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeremy Gray (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Commented: (IBATISNET-18) Improve execution of SqlCommand text
Date Mon, 26 Sep 2005 16:15:59 GMT
    [ 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:
For more information on JIRA, see:

View raw message