I did what lester said to me, and the performance increased very much, now I
am using indexes, and grouping,
I am reorganizing the database, tables, because there are apporoximately
500.000 records that will enter the database. in my study, I am collecting
the stock data from an external txt file, then I am copying the data to gdb,
and getting the result max, min, avr of the prices. after finishing I will
send you,
thanks
kursat

-----Original Message-----
From: Paul Reeves [mailto:paul@...]
Sent: Thursday, December 13, 2001 4:15 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] IBServer too slow wiht 600.000 record


KURSAT TASKIN wrote:

>
> 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
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/