--- In firebird-support@yahoogroups.com, "Anthony Tanas" wrote:

> On the BILLINGLINE I would also like the following but whenever I
> try to do this in one query my query gets EXTREMELY slow (i.e.
> MINUTES)...in the past when I have needed similar information I
> have created calculated fields in my dataset and then ran a
> separate query to get the information.
>
> BILLINGLINE (con't):
> ----------------------
> 9) SUM(PAYMENT.AMOUNT)
> 10 EXTENDED - SUM(PAYMENT.AMOUNT) BALANCE
>
> Previously I got SUM(PAYMENT.AMOUNT) through a VIEW I had created
> called TOTALBIPAYMENTS (SELECT DISTINCT BILLINGITEMID,SUM(AMOUNT)
> FROM PAYMENT GROUP BY BILLINGITEMID)

Show us the SQL, generated plan and give us some information about the
indexes and tables used (e.g. how common are the values of interest
and how big are the tables). That way, we may be able to understand
why the query is slow, and if you're lucky - make suggestions that
help you speed it up and become a serious contender to Daniel ;o)

Set
-working at a Cancer Registry, but inhouse development isn't real
competition.