Thanks Sean...
Thanks about page size...
 

> You have a database transaction that is not committing! 

  How toMake database Commiting ??

> This will cause performance problems.

--- 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, 4:22 PM










> hi all...
>
> this basic question, but make me confuse....
> I use interbase Suoer serve server 6.0, Page Size 1024.
> and every 1 week i move record transaction to another database.
> Because at table MYSS (Sales Transakstion Table) i keep under 20.000
> record. this for performance my application.
> But.. this nigth Running Slow... (my application Not responding)

> ----------
>
> Service started at 24/04/2009 7:28:59
> Database "C:\data\MYXPOSSDB. GDB"
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 8375
> Page size 1024

Increase your page size to 4096!

> ODS version 10.1
> Oldest transaction 434
> Oldest active 8366
> Oldest snapshot 8366

You have a database transaction that is not committing!

This will cause performance problems.

> Next transaction 8367
> ...
> Attributes force write
>
> Variable header data:
> Sweep interval: 20000
> *END*

I would disable sweep (set sweep to 0) and use a schedule task to
perform the database sweep (using GFIX with garbage collection option).

Sean



















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