Subject RE: [firebird-support] How does growing size of FDB effect speed?
Author Alan McDonald
> Hi all
>
> Being a relative newbie I would like to know how the size of an
> FDB effect
> the performance of retrieving data.
>
> As I know that all the data is stored in one huge file. Taking into
> consideration the operating system Window, then when the file keeps on
> growing will it not affect the data access speed?
>
>
>
>
> Regards
> Bhavbhuti

I've never noticed any performance decrease from databases 2Mb->500Mb. If
the indexes are good for the plans of your queries, the performance is fast
across large increases in the db size.
Alan