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/
