Robert martin wrote:

>Hi
>
>I am not a GStat expert but could someone confirm that the following
>stats are OK :)
>
>
>Database header page information:
> Flags 0
> Checksum 12345
> Generation 98195
> Page size 4096
> ODS version 10.1
> Oldest transaction 86406
> Oldest active 86407
> Oldest snapshot 79161
> Next transaction 98186
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 0
> Implementation ID 16
> Shadow count 0
> Page buffers 3000
> Next header page 0
> Database dialect 3
> Creation date Mar 24, 2005 5:03:34
> Attributes force write, no reserve
>
> Variable header data:
> Sweep interval: 20000
> *END*
>
>
>TIA :)
>
>
>

Transactions could be a bit closer, make your transactions short.

Page buffers are too small, are you using classic ou super server ?

If classic, how many concurrent users and how much memory the server has ?

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.1 - Release Date: 23/03/2005