System Running Slowly (OpenInsight Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 09 NOV 1999 10:54:23PM Michael - LMS wrote:

OpenInsight Specific

OI 3.7

Novell 4.11

NLM 1.5

Win 95

We have a problem with anything that accesses one of our main tables taking a long time to run even with indexes on the table. We did a verify on this table and found no GFE's but came up with the following information:

TABLE INFO
 Modulo : 2897
 Sizelock : 0
 Free Frames : 155
 Ave. Disk I/O : 1.041
ROW INFO
 Rows/Group : 28.32
 Ave. Row Length : 29.42
 Row Count : 82057
SIZE (in bytes)
 Primary Frame : 2966528
 Overflow Frame : 692224
 Frame Size : 1024
LOAD FACTOR
 Primary Frame : 0.796
 Overall : 0.672
Does anyone have any ideas how we can optimise the access of data in this table???

Thanks,

Michael

At 12 NOV 1999 10:14AM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura Group[/url] wrote:

Try lowering the threshold to minimise the number of rows per group.

akaplan@sprezzatura.com

Sprezzatura Group

View this thread on the forum...