Myles Wakeham wrote:
> The issue is with one very large table that contains about 900,000
> rows. This table is used as a temporary stora ge of data that is
> loaded every 24 hours from a CSV file, via an external program. The
> loading takes about an hour to run, but works reliably. We are
Hi.
Run gstat and look at info about this table.
Look also at page size of your database. It can be small in 1.5 version, if
yes, change it to bigger value especially 16K.
PS. 900,000 rows is quite small table also for Firebird 1.5
regards,
Karol Bieniaszewski
I have a client with a Firebird 1.5 Classic server that is in the process of
being upgraded to a later version. The database is quite complex and this
upgrade will take some time. However the database has been working well for
the past 8 years, and just in the past few weeks we have seen