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/
