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
http://swoes.blogspot.com/
http://www.flamerobin.org