At 08:42 24/01/2004 +1100, you wrote:

> > > I was following this debate .....
> > > Is Firebird/Interbase that slow ? How does it really compare to
> > MySql
> > > or Ms Sql Server ?
> >
> >
> > I have 5 other applications that use Interbase, and they all run
> > great with respect to speed. It's this particular query I can't get
> > any speed out of.
> >
>z>
> > I definitely don't want to detract from Interbase, I just want this
> > query to run!!
> >
> >
> >
> > Robert Watkins
>
>If you do it as a stored procedure instead of a select, you will be able to
>accumulate the running sub-total without doing a table scan per row
>selected.
>Alan

Hi,

Jumping in the wagon...

When I have to do this kind of "report" I do it on the client-side...
Assumulate in the client site will have 0 cost when presenting the report
(data)... But calculate the running-total for every row will force the
server to perform a sum for every row returned...

see you


Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.564 / Virus Database: 356 - Release Date: 19/01/2004


[Non-text portions of this message have been removed]