SQL Anywhere database - Peformance degradation

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Peformance degradation

Leonid

2005-04-19, 11:23 am

I run ASA 9 in rather intensive environment.
2500 loads(statistics off) of 2500 rows per hour and about
500 of 10000 rows
and many inserts.
Tables of loads dropping and creating.
Tables of inserts truncating before inserts.
There are no indexes triggers.

I initiate DB with 4gig and it remains the same 4gig.
But after hours of such work, performance of loads and
inserts
degrades 3 and more times.

What it means?
Is there a way to keep a good performance I have with clean
DB.

Leonid.

Sponsored Links