> 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