>> How many records approx.? >ok, the select count(*) return ... 4 300 000 record (for last 3 days)
What are the statistics of that database? I just counted 3.6 million records in 1 min 18 seconds (albeit that table contains 50 years of history, not 3 days, so the system isn't anywhere as busy as yours), so more than an hour to count 4.3 million records sounds like a bit longer than I would expect. One reason can be if there is a big gap between oldest active transaction (or it could be oldest interesting transaction, I always mix these up) and next transaction, if so, you have might have a transaction problem (Firebird can contain several versions of the same record, each version potentially visible to different transactions and discovering which version (if any) is visible to your transaction can be time consuming). With a system like yours that inserts 1000 records per minute (presumably only a few records per transaction) and also do some updating, it is important to ascertain that no transaction lasts too long. Svein Erling
