From: giorgi giorgi [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2008 09:41
To: For users and developers of the Firebird .NET providers
Subject: Re: [Firebird-net-provider] ExecuteReader is slow
Hello,
I am using 2.1 version of firebird. Fb.NEt provider version is 2.0.1.0
Connection 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
[PM] First: if database is on Windows change database name from name.gdb to
name.fdb or something different from gdb
Second: if you run thins from isql, fbexpert or what you use for design, can
you show the plan for this sql?Maybe you don’t have index on smth and/ or bal
field.
Regards,
Paul
-------------------------------------------------------------------------
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
