Maybe you should change this to a stored procedure and pass parameters … should
run more faster then your code!
From: giorgi giorgi [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2008 10:24
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] ExecuteReader is slow
Well, it is fast if you call it once but for 2000 class it's about one minute.
It's taking about 85% of the whole action.
On Tue, Sep 30, 2008 at 11:16 AM, Steve Faleiro <[EMAIL PROTECTED]> wrote:
IMHO, 0.028 seconds seems to be pretty quick. That is 3/10ths of a
second. What were you expecting?
--- giorgi giorgi <[EMAIL PROTECTED]> wrote:
> 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.
>
-------------------------------------------------------------------------
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
<http://moblin-contest.org/redirect.php?banner_id=100&url=/> &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
