Why does turning off file cache help? The little help screen says you can assign a level from 0-3, the higher the better!
Mike Sinclair Troy Sosamon wrote: > In the Novell 2000/NT client there is also a file caching setting you want to > turn off. > > Troy Sosamon > > >===== Original Message From [EMAIL PROTECTED] ===== > >On the Novell side of the equation check the client that you are using. The > >4.7 client for Win 2000/NT has opportunistic file locking turned on by > >default, and does not allow the user to change the setting. This setting is > >supposed to enhance network access speed, but when dealing with databases in > >general it causes great pain. You can either down grade to the NetWare > >client 4.6 or upgrade to the current version 4.81 any version except 4.7 > >seems to work fine. Good Luck! > > > >Charles E. Knapp Jr. > >Information Services Director > >Woodloch Pines Inc. > >RR 1 Box 280 > >Hawley, Pennsylvania 18428-9757 > > > >voice: 570.685.8027 > >FAX: 570.685.8095 > > > >web address: www.woodloch.com > >e-mail: [EMAIL PROTECTED] > > > > > >-----Original Message----- > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > >Behalf Of Chuck Lockwood > >Sent: Monday, February 25, 2002 10:48 AM > >To: [EMAIL PROTECTED] > >Subject: RE: Re: Performance with 1 vs 2 users > > > > > >Upgrade the Novel client on the offending workstation(s), there was a > >problem with a version of the Novel client that would exhibit these results. > > > >Chuck Lockwood > >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > >LockData Technologies, Inc. > >309 Main Avenue, Hawley, Pa 18428 > >Phone: 570-226-7340 ~ Fax: 570-226-7341 > >Email: [EMAIL PROTECTED] ~ http://www.lockdata.com > >~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > > > > > >-----Original Message----- > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > >Behalf Of Albert Berry > >Sent: Monday, February 25, 2002 9:34 AM > >To: [EMAIL PROTECTED] > >Subject: RE: Re: Performance with 1 vs 2 users > > > > > >This is a problem with W2K servers. We have not yet tested with Patch 2, > >but up to Patch 1 there is a serious performance hit by simply having a > >second user connect to a database. This user need not be doing anything. It > >doesn't matter whether it is RBDOS or RBWin. > > > > > >MJS <[EMAIL PROTECTED]> wrote: > > > >>Question......can we at least confirm this as a problem? If it's happening > >on Win2k servers and Novell servers it should be worth the effort to track > >it down. I > >>could probably try to see if it's a network traffic issue by using a packet > >sniffer, but I don't want to reinvent the wheel. Did you narrow it down to > >anything? > >>or exclude anything? > >> > >>Mike > >> > >>Albert Berry wrote: > >> > >>> We delved into this scenario quite a bit. M$ blames RBTI, RBTI could not > >provide a solution either. 10:1 the server is W2K > >>> > >>> MJS <[EMAIL PROTECTED]> wrote: > >>> > >>> >Hi all, > >>> >A strange thing (at least I think it's strange) showed up today in > >Rbase. The > >>> >database is on a server. I connect with just one station, and run a > >program > >>> >which uses a declare cursor to check data in a bunch of rows. The > >program > >>> >completes in 10 seconds, plus or minus 1 second. I sometimes use this > >program > >>> >as a test for performance. Now....just for grins, I run Rbase on an > >additional > >>> >station, but I don't connect to the database... I just let the computer > >sit at > >>> >an R>. Keep in mind, these are the only 2 stations that are attached to > >Rbase, > >>> >1 connected to the database, 1 not connected to the database. Nobody > >else is > >>> >around, no other programs are being run on the server. I run the same > >program > >>> >again, same results, 9-11 seconds to finish. NOW.......I go to the > >second > >>> >machine, and just do a > >>> >CONNECT dbname (multi user is on, staticdb is on). No other programs > >are > >>> >running. Now I run the same program again.....40 seconds!! 400% > >longer!!!! > >>> >Does this make sense? Network traffic should be about the same, so I > >don't > >>> >think it;s a network issue. Any ideas or comments? > >>> > > >>> >TIA! > >>> > > >>> >Mike Sinclair > >>> > > >>> >================================================ > >>> >TO SEE MESSAGE POSTING GUIDELINES: > >>> >Send a plain text email to [EMAIL PROTECTED] > >>> >In the message body, put just two words: INTRO rbase-l > >>> >================================================ > >>> >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >>> >In the message body, put just two words: UNSUBSCRIBE rbase-l > >>> >================================================ > >>> >TO SEARCH ARCHIVES: > >>> >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >>> > > >>> -- > >>> > >>> __________________________________________________________________ > >>> Your favorite stores, helpful shopping tools and great gift ideas. > >Experience the convenience of buying online with Shop@Netscape! > >http://shopnow.netscape.com/ > >>> > >>> Get your own FREE, personal Netscape Mail account today at > >http://webmail.netscape.com/ > >>> > >>> ================================================ > >>> TO SEE MESSAGE POSTING GUIDELINES: > >>> Send a plain text email to [EMAIL PROTECTED] > >>> In the message body, put just two words: INTRO rbase-l > >>> ================================================ > >>> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >>> In the message body, put just two words: UNSUBSCRIBE rbase-l > >>> ================================================ > >>> TO SEARCH ARCHIVES: > >>> http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >> > >>================================================ > >>TO SEE MESSAGE POSTING GUIDELINES: > >>Send a plain text email to [EMAIL PROTECTED] > >>In the message body, put just two words: INTRO rbase-l > >>================================================ > >>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >>In the message body, put just two words: UNSUBSCRIBE rbase-l > >>================================================ > >>TO SEARCH ARCHIVES: > >>http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >> > >-- > > > > > > > > > >__________________________________________________________________ > >Your favorite stores, helpful shopping tools and great gift ideas. > >Experience the convenience of buying online with Shop@Netscape! > >http://shopnow.netscape.com/ > > > >Get your own FREE, personal Netscape Mail account today at > >http://webmail.netscape.com/ > > > >================================================ > >TO SEE MESSAGE POSTING GUIDELINES: > >Send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: INTRO rbase-l > >================================================ > >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: UNSUBSCRIBE rbase-l > >================================================ > >TO SEARCH ARCHIVES: > >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > >================================================ > >TO SEE MESSAGE POSTING GUIDELINES: > >Send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: INTRO rbase-l > >================================================ > >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: UNSUBSCRIBE rbase-l > >================================================ > >TO SEARCH ARCHIVES: > >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > > >================================================ > >TO SEE MESSAGE POSTING GUIDELINES: > >Send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: INTRO rbase-l > >================================================ > >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: UNSUBSCRIBE rbase-l > >================================================ > >TO SEARCH ARCHIVES: > >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > Troy Sosamon > Denver Co > [EMAIL PROTECTED] > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
