How necessary are the Flush and GarbageCollect functions in the NT and Novell environments? Should they be included in every stored proc and script?

Flush is an attempt to close unused file handles.

Garbagecollect is an attempt to pack all variables into string space contiguously, thus making the largest available pool of contiguous free string space. Not unlike "defragmenting" a disk, but done in RAM.

In a network environment, every time you open a file someone else on the network has already opened, you make a truckload of work for the NOS. So closing files with flush means that you save the network resources.

Garbagecollect will be of value in reducing memory utilitization any time, regardless of network or standalone. Flush (because of caching etc.) may be a waste of time on some occasions, but can still assist with reducing network resource contention.

Steve

Thanks, Steve

View this thread on the forum...