Archiving Database in Progress 8.3B

[dlaiser]

It is my first time to post a question in this forum.

I have a huge problem in my working database.

We are using progress 8.3B for our billing system, and it runs on unixware 7.1.3. The database is keep on getting bigger, and results poor performance in the application.

Is there any one who knows how to do an archive? or is there any tool that might help?

Regards.

 

[TomBascom]

When performance deteriorates as a db grows it generally means that you lack appropriate indexes. That's usually fixable.

Although it could also mean that you have some really truly foul coding (perhaps your code is deliberately looking at millions of records and then only processing the last one or some other really bad algorithm).

Archiving data depends entirely on the design of the application. If it is a well known commercial application then there might be a standard tool. If it is something that you wrote yourselves then the archiver will also need to be home grown.

8.3 is ancient history. You really ought to upgrade.