Subject IBServer too slow wiht 600.000 record
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.

thanks to every body