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/
