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
