Subject | RE: [firebird-support] How does growing size of FDB effect speed? |
---|---|
Author | Alan McDonald |
Post date | 2004-04-05T11:04:42Z |
> Hi allI've never noticed any performance decrease from databases 2Mb->500Mb. If
>
> 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
the indexes are good for the plans of your queries, the performance is fast
across large increases in the db size.
Alan