I have a file with a record size of 3000. What would be the best frame size and threshold for speed? I was thinking 9216. Suggestions

[notag]A point made at Rev U was that this very much depended on whether you were using the NLM/NT Service. If so the optimum size was 8K. (With a caveat that 32K might be better but there was no guarantee that this was supported throughout the system). [<A HREF="[<A HREF="http://www.revelation.com/8525652b0066bfaf/d739a1010f28f6798525656b00612ab1/24ea8e04926b6b42852566e4004fe037?OpenDocument" onMouseOver="window.status='Read another thread on the subject';return(true)">See also this thread.</A>]

[<A HREF="mailto:amcauley@sprezzatura.com" onMouseOver="window.status='Why not click here to send me Email?';return(true)">Andrew McAuley</A>]

[<A HREF="http://www.sprezzatura.com" onMouseOver="window.status='Why not click here to visit our web site?';return(true)">Sprezzatura Group</A>]

[<I>World Leaders in all things RevSoft</I>]

[<img src="http://www.sprezzatura.com/zz.gif">]

[<script language="javascript">function openNewPage () {window.location.href=(document.TOCNavigator.pageToGoTo.options[document.TOCNavigator.pageToGoTo.selectedIndex].value);document.TOCNavigator.pageToGoTo.selectedIndex="0";}end hiding from non-JS browsers –></script>] [<FORM ACTION "" METHOD=GET NAME="TOCNavigator" <SELECT NAME="pageToGoTo" SIZE=1 onChange="openNewPage()"> <OPTION>Pull down this menu to choose whereabouts on Sprezz site to go <OPTION VALUE="http://www.sprezzatura.com">Home Page <OPTION VALUE="http://www.sprezzatura.com/whatsnew.htm">What's New <OPTION VALUE="http://www.sprezzatura.com/senl.htm">SENL <OPTION VALUE="http://www.sprezzatura.com/patches.htm">Download S/LIST <OPTION VALUE="mailto:support@sprezzatura.com">Send mail to support at Sprezzatura <OPTION VALUE="mailto:sales@sprezzatura.com">Send mail to sales at Sprezzatura </SELECT> </FORM>][/notag] </QUOTE> —- === At 10 MAY 1999 09:35AM akaplan@sprezzatura.com - Sprezzatura Group wrote: === <QUOTE>My understanding has been that while the optimum for the NLM/NT service might be based on 4K, you're still better off setting frame size based on your record size. Packet size is somewhat irrelevant now since you are only getting back the record anyway, not giant frame blocks. You wouldn't want to set VOC to an 8K frame size though. You still want to minimize the number of records per frame and also minimize the amount of overflow frames. As mentioned, this is only relevant for the NLM/NT Service. Without these, you must ensure all your frame sizes are the same on all files. akaplan@sprezzatura.com Sprezzatura Group </QUOTE> —- === At 11 MAY 1999 06:30AM Barry Stevens wrote: === <QUOTE>Would setting frame size to 8k on a single PC be ok, I assume you mean if running network and not service there is some sort of problem. Frame size is something I have never ever thought about, does it make a big performance difference… with NT Service. Barry </QUOTE> View this thread on the Works forum...