Hi all

I have a customer who has a very large file, part of it is over 92MB in size. He keeps getting GFE in group 0. We've found a backup that doesn't have GFE in group 0 but as soon as he starts using it, and adding data, it GFE group 0 again.

I was thinking of taking the good restore and making a new table and copying the records across but I don't know how to find out the optimum attributes like average row size, number of rows, what frame size to use. There are a few users (maybe 20?) for this system. And resize threshold.

I think something must be going wrong with the resize, ie it gets to the resize but gets too many update requests at the same time.

I also think there might be problems with virus scanners, write behind cache, network services, and table updates not being managed neatly.

How do I find out what I should put for the table attributes with maketable?

Thanks

Janet

Janet

Frame sizes et al are a red herring for the most part. Group 0 GFEs are caused by locking/cacheing, so first off ensure that there's a REVPARAM in place if they're using a network product. Also ensure Write Behind Cacheing off on 98 and 2000 boxes.

[email protected]

The Sprezzatura Group Web Site

World Leaders in all things RevSoft

Hi Sprezz

Thanks for that. Damn, Revparams are an all or nothing prospect. And I know they've got the network service but I'm not sure if it is setup correctly (System user and all that). I will see if we can implement the revparam bit.

View this thread on the forum...