Slow OI on NT (OpenInsight Specific)
At 11 MAY 2000 12:46:39PM Colin Rule (CSSP) wrote:
A user is getting frustrated with slow performance.
They have upgraded to high spec Pentium IIIs running NT workstation
The server is a high spec NT, running the Revelation NT service.
There are no additional network protocols.
Oengine is 3.7.2
All networks driver 1.5.0.0
Any ideas where else we may be able to offer advice on finding the root cause of the speed problems.
Thanks
Colin
At 15 MAY 2000 06:13AM Mike wrote:
Colin
just an idea, are they using a virus checker. may be something to do with how it was installed.
Mike
At 01 JUN 2000 04:11AM Robert Lee wrote:
Colin
I don't know about your app, but if you have tables that are growing fast, you may find the table(s) have become inefficient. Go into database manager, Utilities, OI tables, LH Verify and choose the main tables your user is working with. Do a verify and then view the detail. There is a dazzling array of information telling you how efficient your tables are (or aren't). Danger signs are average disk IO being more than about twoish, overflow frame larger than the primary frame. You can "REMAKE" tables so they become efficient. Do a search - I think there is plenty of info on it. I believe it is even possible to remake system tables like Sysrepos but I haven't done it yet. We have achieved an improvement of 45 minutes down to 3 minutes for one process.
It can even be done programatically. I would like to create a "housekeeping" module to sell to the punters which would includes this "remaking". I'm sure they would be prepared to pay for that kind of performance increase.
Robert