[[https://www.revelation.com/|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]]


==== System Running Slowly (OpenInsight Specific) ====
=== At 09 NOV 1999 10:54:23PM Michael - LMS wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
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
</QUOTE>
----

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

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







akaplan@sprezzatura.com

[url=http://www.sprezzatura.com]Sprezzatura Group[/url]

[img]http://www.sprezzatura.com/zz.jpg[/img]







</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=3C2B81D5CFD45B3385256825001575B3|View this thread on the  forum...]]