Database optimalization?

[sipek]

Hello,

Could you please give a clue how to optimalize/reindex/cleanup database in MFG?

Slawek

 

[Kishor Chari]

What is the Hardware/OS/Number of users?

 

[Kishor Chari]

What is the Hardware/OS/Number of users? And Version of MFG/PRO

 

[gtmsb]

If I am using Window Server, eb version, Progress 9.1c & 10 concurrent users, What should I do? Thank you

 

[Kishor Chari]

With 10 users you dont need much, if your db is 5+ yr old, create a backup database & delete archive data on the live server at this time do a dump & load.
Ensure your server is private for MFG/PRO , if it is used as file server or Exchange server your MFG/PRO performance will detoriate.

 

[gtmsb]

OK. Thankx.
My MFGPRO is a standalone server!
No other applications.

 

[Kishor Chari]

Then a single archiving act will give you good results.