Mike, I need more info to really help with this problem. I have run R:base on every version of Novell except the latest version 6.
What version of R:base? What is the OS of the workstations? What is your program doing? One thing to keep in mind that once you add that second user to the database, now updates have to check for concurency control. Depending on the size of your tables and your indexes, updates, inserts, and deletes can get slow. If you are doing bulk updates on big tables, there is a lot of overhead checking for concurency. This is where the various settings can make big differences. Here are some settings I recomend: SET VAR MICRORIM_F2MAXBLK INT = 64 SET VAR MICRORIM_F3MAXBLK INT = 256 SET VAR MICRORIM_BTMAXBLK INT = 64 SET VAR MICRORIM_SRTMAXBLK INT = 64 SET STATIC ON SET ROWLOCKS ON SET QUALCOLS 10 -- page locking - large updates require fewer locks SET TRANSACT OFF SET MULTI ON SET WHILEOPT OFF -- very few apps gain from this, and it can cause problems Some of this stuff works a little differently depending on the version of R:base you are using. The static setting is good, that gives you some performance help because updates don't have to check for structure changes. Every version of R:base that comes out continues to be tweeked at the engine level for performance, and every release gets faster. You might want to check the Novell properties on the directory and on the database files. I don't have NW 6, so I don't know what to tell you to look for. Troy Sosamon >===== Original Message From [EMAIL PROTECTED] ===== >We have also not had the problem on a Novell 4 server at several different >clients. > >======================================= >At 09:35 AM 2/25/2002 -0500, you wrote: >>My comment was not clearly written. The problem we have identified is >specific to W2K servers. We do not run Novell, but did not have the problem >on a Novell 4 test server. >> >> >>MJS <[EMAIL PROTECTED]> wrote: >> >>>The Server is NOVELL 6.0! >>> >>>SO......what's it gonna take to fix this? >>> >>>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/ 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/
