Stephen, I was having a problem with long connect times. John Minyo gave me a tip....reduce the number of files in the starting directory to a bare minimum. Apparently Rbase 9.1 is sensitive to the total number of files in the starting directory. When I moved the unnecessary files out of the starting folder, the connect time decreased dramatically. Just my 2 cents worth. Mike
________________________________ From: Stephen Markson <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, November 28, 2011 1:43 PM 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
