At 02:17 PM 27/04/2009, you wrote:

>For All....
>I am sorry... i am wrong sent the database statistic. and this database statistic and Ibconsole after my application Slow down....
>I am Confuse because this application start running at feb 2008. and until Desember 2008 starting slow down .. and try to move record to database backup and run Backup and restore, well done. But start february 2009 every 1 month must be remove data transaction to backup database and must be backup restore for more faster on my application. but this month, 2 week running my application slow down again. Need correcting on my database server and parameter to make the best performance.
>Spec Server :
> Window server 2000
> interbase 6.0
> Intel P IV xeon
> 2 gb RAM
> HD scsi 100 gb
> 40 Client Computer to access database
>
>IbConfig:
>#V4_LOCK_MEM_SIZE 98304
>#V4_LOCK_SEM_COUNT 32
>#V4_LOCK_SIGNAL 16
>#V4_EVENT_MEM_SIZE 32768
>#DATABASE_CACHE_PAGES 10000
>#SERVER_PRIORITY_CLASS 1
>#SERVER_CLIENT_MAPPING 4096
>#SERVER_WORKING_SIZE_MIN 0
>#SERVER_WORKING_SIZE_MAX 0
>#V4_LOCK_GRANT_ORDER 1
>#ANY_LOCK_MEM_SIZE 98304
>#ANY_LOCK_SEM_COUNT 32
>#ANY_LOCK_SIGNAL 16
>#ANY_EVENT_MEM_SIZE 32768
>#CPU_AFFINITY 1
>
>Database Statistic:
>Database "c:\data\myxpossdb250409.gdb"
>
>Database header page information:
> Flags 0
> Checksum 12345
> Generation 8840430
> Page size 8192
> ODS version 10.1 <<<========================
> Oldest transaction 8840412
> Oldest active 8840413
> Oldest snapshot 8840413
> Next transaction 8840419
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 0
> Implementation ID 16
> Shadow count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Creation date Apr 4, 2009 7:52:21
> Attributes force write
>
> Variable header data:
> Sweep interval: 20000
> *END*

1. You have an InterBase configuration file, but all of its configurations are commented out, anyway. How are you setting the page cache and how big is it?

2. You say that you are running IB 6.0 **but** those statistics were taken from a Firebird 1.5 database (ODS 10.1). What exactly is going on there? You are running IB 6 but using Firebird to do your restores?

3. Were any users logged in when you took these statistics?

./heLen