Hello,
I am using 2.1 version of firebird. Fb.NEt provider version is
2.0.1.0Connection string looks like this:
"User=SYSDBA;Password=masterkey;Datasource=xxx;Database=name.gdb;" (xxx is
just symbolic here)
Command looks like this:
"SELECT SUM(nsum), card FROM op WHERE
smth >= @from AND smth<= @to AND
bal = @code group by card"
from, to and code parameters are added during runtime. When I call
ExecuteReader it takes too much time, about 0.028 seconds.
On Mon, Sep 29, 2008 at 9:18 PM, Mercea Paul <[EMAIL PROTECTED]> wrote:
>
>
>
>
> *From:* giorgi giorgi [mailto:[EMAIL PROTECTED]
> *Sent:* Monday, September 29, 2008 12:53
> *To:* firebird-net-provider@lists.sourceforge.net
> *Subject:* [Firebird-net-provider] ExecuteReader is slow
>
>
>
> Hello,
>
> I am developing an application that uses firebird database and I use
> firebird provider for ado.net The application makes many calls to
> ExecuteCommand method of FbCommandClass. According to .net performance
> provider it is the slowest method and takes about 0.028 seconds to execute.
>
> Why does it happen? How can I optimize it?
>
> Thanks.
>
> *[PM] *
>
> Hi
>
> Is slow retated to ... ???
>
> Please provide more info !
> What FB superserver\clasic you use?
> What FB.Net <http://fb.net> Provider version?
> Whats the connection string?
> How looks your command?
>
> Regards,
> Paul
>
> -------------------------------------------------------------------------
> This SF.Net <http://sf.net> email is sponsored by the Moblin Your Move
> Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great
> prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider