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*
 
 
Database file sequence:
File c:\data\myxpossdb250409.gdb is the only file
 
Database log page information:
 Creation date
 Log flags: 2
  No write ahead log
 
 Next log page: 0
 
    Variable log data:
 Control Point 1:
  File name: 
  Partition offset: 0  Seqno: 0  Offset: 0 
 Control Point 2:
  File name: 
  Partition offset: 0  Seqno: 0  Offset: 0 
 Current File:
  File name:  
  Partition offset: 0  Seqno: 0  Offset: 0 
 *END*
 
Analyzing database pages ...
MYSS (179)
    Primary pointer page: 319, Index root page: 320
    Data pages: 744, data page slots: 1599, average fill: 49%
    Fill distribution:
  0 - 19% = 254
 20 - 39% = 39
 40 - 59% = 27
 60 - 79% = 263
 80 - 99% = 161
 
    Index MYSS1 (1)
 Depth: 2, leaf buckets: 11, nodes: 11558
 Average data length: 0.00, total dup: 10313, max dup: 172
 Fill distribution:
      0 - 19% = 0
     20 - 39% = 0
     40 - 59% = 3
     60 - 79% = 0
     80 - 99% = 8
 
    Index MYSS2 (0)
 Depth: 2, leaf buckets: 15, nodes: 11541
 Average data length: 0.00, total dup: 11517, max dup: 1916
 Fill distribution:
      0 - 19% = 1
     20 - 39% = 1
     40 - 59% = 8
     60 - 79% = 1
     80 - 99% = 4
 
    Index MYSS3 (3)
 Depth: 2, leaf buckets: 13, nodes: 11558
 Average data length: 1.00, total dup: 9792, max dup: 172
 Fill distribution:
      0 - 19% = 1
     20 - 39% = 1
     40 - 59% = 2
     60 - 79% = 1
     80 - 99% = 8

ASAP, Hope Solution/idea/correcting on my database server.
Thanks....

--- On Fri, 4/24/09, Leyne, Sean <Sean@...> wrote:

From: Leyne, Sean <Sean@...>
Subject: RE: [firebird-support] Still About performance and running slow
To: firebird-support@yahoogroups.com
Date: Friday, April 24, 2009, 5:53 PM








Douglas,

> On Fri, Apr 24, 2009 at 5:22 PM, Leyne, Sean
<Sean@broadviewsoftw are.com>
> wrote:
> >> Oldest transaction 434
> >> Oldest active 8366
> >> Oldest snapshot 8366
> >
> > You have a database transaction that is not committing!
>
> The difference between Oldest Transaction and Oldest Active is the
> number o transactions that need sweeping.
> When transactions are left uncommited, it's the difference between
> Oldest Active and Next that increases.

You are correct, my bad!

I was too quick in reviewing the details... ;-[

Sean



















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