Hi,

> 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)

> 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.

Although Set is correct, there are still too little transactions and as for
what you've said you "problem" table is only about 20k records?? I can't see
how you could get slow performance from this...

...it must be some other issue. I've seem cases where numbers were at least
thousand times worse and the performance was still fine.


Regards,
Anderson Farias