Subject Re: [firebird-support] Pinning Table data in memory
Author Milan Babuskov
Hemant.Sapre@... wrote:
> Is there any way in Firebird that will enable the database to hold / pin
> all records in memory so that disk I/O is reduced and performance is
> improved?
> Our application requires data to be fetched from 30 Million+ records in
> the table and the response time needs to be very good.

Perhaps you should look into Netfrastructure then.

But before you go into it, why don't you make a test (with test data)
and see how Firebird behaves. Having the "right" indexes can do wonders,
even for 30 Million+ tables.

Milan Babuskov