Subject Re: [ib-support] IBServer too slow wiht 600.000 record
Author Paul Reeves
> 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.

30 minutes is 1800 seconds. 333/600.000 is about 1800. You are processing one
stock code per second. From your description it is hard to tell whether that
is good or bad performance.
Can you post the table structures, indexes and the code for the SP?


Paul Reeves
taking InterBase further