I'm just trying to make the system run as fast as it can to see
where the slowness is coming from.

But, with the new options the have been put in
place,MaxUnflushedWrites and MaxUnflashedWriteTime I don't see it as
that big of an issue any longer...

But, back to my question about the indexes...

--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:

> > Were the changes to the indexes in 2.0 suppose to provide more

than

> > larger indexes?
> >
> > The reason I'm asking is because some of my queries still run

just

> > as slow in 2.0 as they did 1.5.2.
> >
> > Ex. SELECT distinct store_no from mytable; (Does a table scan)
> > Thanks
> >
> > P.S. My restore time was cut in half from 50 mins on 1.5.2 to

26

> > min with 2.0 !! (DB Size 2.6 Gig)
> >
> > System Specs:
> > WinXP Pro. SP 2
> > 2.6 MHZ
> > 512 MB RAM
> > ODSVersion = 11.0
> > Charset = NONE
> > PageSize = 8192
> > PageBuffers = 32768
> > SQLDialect = 3
> > SweepInterval = 20000
> > ForcedWrites = False
> > ReadOnly = False
> >
>
> I hope you have adequate insurance with ForcedWrites set to OFF
> Alan