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> > 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> 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 > ------------------------------------------------------------------------- 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
