[[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]]


==== Hanging at the TCL (AREV Specific) ====
=== At 22 OCT 1999 02:38:03PM *********** Mike Daniel ********** wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
Does anyone have any idea why AREV 3.12 hangs randomly at the TCL

when issuing a OFF cmd.



Also does useing net use cmds cause a lot of GFE's?



Thanks

mdaniel@usunwired.net

mdaniel@pcsla.com
</QUOTE>
----

=== At 23 OCT 1999 05:42PM Richard Hunt wrote:  ===

<QUOTE>I have had similar problems. I have considered that it might be sourcing from the "SYSTEMP" table. All information in the "SYSTEMP" table is temporary information. So if you are the only user on the system you can "CLEARTABLE SYSTEMP" without problems.



NOTE!!!  The "SYSTEMP" table might contain bits of things that are important... like when tables get "GFE"'s and you fix the table... the remainning bits of "ROWS" that the system can not fix are put in the "SYSTEMP" table.



I do know when you do "SELECTS" or "SORTS" the "SYSTEMP" table is used to store the "LISTS" that are greater than 64K. So the "ROWS" in the "SYSTEMP" table can be very very very big and time consuming for the system to handle.



Still this only "kinda" helps fix the problem. Not too sure what else to say about it.

</QUOTE>


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