1. I changed query but ut's the same.
2. Yes, there are ascending indexes.
3. Not very. The file is about 3Gb and op table has about 4,000,000 records.
4. Executing stored procedure takes the same time. According to profiler it
is Prepare method that takes most of the time.
5. IBExpert 2.0 seems to run query faster but I can be mistaken.
By the way, calling read() on returned FBdatareader is slow too.
On Tue, Sep 30, 2008 at 12:29 PM, Steve Faleiro <[EMAIL PROTECTED]> wrote:
>
> 1. Did you try to optimize the query? I know Firebird has an optimizer
> that optimizes every query but sometimes a
>
> Instead of:
>
> > "SELECT SUM(nsum), card FROM op WHERE
> > smth >= @from AND smth<= @to AND
> > bal = @code group by card"
>
> Try:
>
> > "SELECT card, SUM(nsum) FROM op WHERE
> > smth >= @from AND smth<= @to AND
> > bal = @code group by card"
>
>
> 2. Are the columns 'card', 'smth' and 'bal' indexed ?
>
> 3. Is the database in good condition, did you do a sweep / repair ?
>
> 4. Is this the only query that is taking too long or are all other
> queries run by your application showing performance degradation?
>
> 5. Did you try the same query against the same database and server using
> another query tool? ( Eg. IBExpert )
>
>
> These are just some points I can think of.
>
>
> --- giorgi giorgi <[EMAIL PROTECTED]> wrote:
>
> > 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 <http://fb.net> <
> http://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 <http://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 <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 <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
