@helen...
*Page_cache i change at Feb 2009. before still default 75.
 
at server Interbase 6.*
but i copy database to my comp and i m running database statistic on my comp.

--- On Mon, 4/27/09, Helen Borrie <helebor@...> wrote:

From: Helen Borrie <helebor@...>
Subject: RE: [firebird-support] Still About performance and running slow
To: firebird-support@yahoogroups.com
Date: Monday, April 27, 2009, 4:22 AM








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\myxpossdb2 50409.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



















[Non-text portions of this message have been removed]