Thanks for your info. Last night I read up about tuning databases,
and I got some insight on the usage of page size. Since then I've
created another database with page size = 8192. Bingo... it works
faster. Thanks again.

--- In firebird-support@yahoogroups.com, "Alexander V.Nevsky"
<ded@h...> wrote:

> --- In firebird-support@yahoogroups.com, "Alfred Seetoh"
> <cwseetoh@s...> wrote:
> > Forced Writes are enabled for both databases. However I do notice
> > some differences between the 2 of them.
> >
> > Config FB 1.0 FB 1.5
> > ====== ====== ======
> > Page Size 8192 1024
> > ODS Version 10.0 10.1
> > Buffers KB 16384 2048
> >
> > Could the difference page size and buffers cause the difference

in

> > speed?
>
> Certainly. Look at
>
> http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_conf_opt
>
> Article is rather old, so check Release Notes of used
> version for description of new configuration parameters.
> Recommendation for most general case - make page size equal to disk
> cluster size used in OS. About cache buffers - for Superserver

about

> 10000, for Classic 75. For database with complex metadata structure

on

> Classic it can be useful to tune this experimentally increasing and
> checking performance.
>
> Best regards,
> Alexander.