--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
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.
> >
> >
> > 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

Good idea!! I will try that out this weekend. I will post
results....