> Run gstat -h and report back.
>
>
> --
> With regards,
>
> Thomas Steinmaurer

Hello Thomas, Page buffers is 0, the database has a lot of metadata, more than 1000 tables 3000 triggers and 1500 stored procedures.

If classic server uses 100 MB per client connection, then classic is not for me, but i don't know how to improve performance for 100 or more users.


Database header page information:
Flags 0
Checksum 12345
Generation 16764
Page size 8192
ODS version 11.2
Oldest transaction 3220
Oldest active 16672
Oldest snapshot 16672
Next transaction 16752
Bumped transaction 1
Sequence number 0
Next attachment ID 96
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 1
Creation date Apr 28, 2011 11:10:03
Attributes force write

Variable header data:
Sweep interval: 20000
*END*

Regards, Jesus García