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