I take back what I said. The delay when switching databases appears to be related to the number of connected users. Delay is almost negligible if only a few users...
Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Dan > Goldberg > Sent: Monday, November 28, 2011 4:23 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Nice feature in 9.1 > > My users switch databases in the application and there is a delay. Odbc > is > good but is slower. Maybe they will put it in 9.5? > > Dan Goldberg > > -----Original Message----- > From: Javier Valencia > Sent: Monday, November 28, 2011 1:13 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Nice feature in 9.1 > > Dan, > > I agree that a native link to other R:Base databases would be a great > and > much needed update. > I have been doing some research on ODBC connections, as I need to > connect a > GIS application to spatial databases, and the consensus (in the other > databases communities) is that any connection via ODBC adds a fair > amount of > overhead and that native links are the most efficient. I am not sure if > this > is the case with R:Base, but it would not surprise me if it did. > > Javier, > > Javier Valencia, PE > O: 913-829-0888 > H: 913-397-9605 > C: 913-915-3137 > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Dan > Goldberg > Sent: Monday, November 28, 2011 12:53 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Nice feature in 9.1 > > I have one of my requests to natively link other R:Base databases > without > using odbc. I think it used to be possible many moons ago but somewhere > it > was removed. > > The "other" guys you can link to other similar databases natively > without > having to use odbc. > > Dan Goldberg > > -----Original Message----- > From: Stephen Markson > Sent: Monday, November 28, 2011 10:43 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Nice feature in 9.1 > > Hello all, > > Just finished converting our 30+ users from 7.6 Full Version to 9.1(32) > runtime. We had a few bumps but it was well worth the change. > > One of the features that really helped was the reduction in time > required to > connect to a database. We log activities in our application to a > separate > R:Base database. In 7.6, the time required to connect to the other > database > and then reconnect to the original database was prohibitive. As a result > we > used ODBC and SATTACHed the activity logging table. With runtime, > though, > the ODBC driver is not available. No problem in 9.1! The time required > to > CONNECT to the logging database, INSERT into the logging table and > re-CONNECT to the original database is under 300 ms. > > > Regards, > > Stephen Markson > The Pharmacy Examining Board of Canada > 416.979.2431 x251 >
