wow - definitely
make it 4096 minimum - this is ofen a cause of slowness in my experience
especially where blob fields are around - try also 8192 and see the
difference
Alan

> -----Original Message-----
> From: Tim Ledgerwood [mailto:tim@...]
> Sent: Friday, 5 December 2003 5:23 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Strange performance problems
>
>
>
> >64MB isn't a lot for running Windows, a database server, and the app plus
> >client s/w.
> >What is the page size and no. of cache pages? Is it the same
> >everywhere? With 8KB pages and 8000 cache pages you're using about 64MB
> >just for the database.
> >You should also check the statistics on the header page to make sure the
> >sweep thread doesn't take all the resource (however, this
> shouldn't be very
> >often) - backup+restore cures this temporarily... Permanent
> solution: mind
> >the transactions.
> >
> >The 'max dup' on many of the indexes may be a problem on
> DELETEs, but this
> >is easily fixed.
>
> Hi Aage,
>
> Page size is 1024, and there are 73122 allocated pages. Maybe I
> should increase
> the page size?
>
> Speaking to one of our technical guys, he agrees that 64 MB isn't a lot
> when running
> Windows (especially W 98 on the FAT system), as well as other apps.
>
>
> Regards
>
> Tim
>
>
> [Non-text portions of this message have been removed]
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>