> Hi, I am using latest version of firebird. I created a procedure in order to
> calculate max, min, average stock prices of selected firms. I have 333
> different stock code and approximately 600.000 daily records. in my
> procedure, I am first selecting the code, then I am searching this code in
> the main database, select * from ... where ....code=:code_var
> then updating the table that contains unique stock codes and fields for max,
> min and average prices. it calculates, but too slwo, approximatly 1/2 hour.
> is this possible or there is a fallacy with me.

Have you tried -

SELECT MAX(PRICE), MIN(PRICE), SUM(PRICE), COUNT(PRICE)
FROM XXX
WHERE CODE=:CODE_VAR
GROUP BY STOCKCODE

Have you got an index on STOCKCODE and on PRICE

( I think there is an AVR, but may be getting confused with
FastReport )

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services