Is there any reason why you did not test RMySQL on Windows or RODBC on Solaris: the latter seems an obvious test?
On Fri, 24 Jan 2003, Malladi, Sukhaswami wrote: > R-help list, > > I ported some R code from MS Windows PC to sun-solaris. Both do queries on > the same > MySQL database. > > PC version of R is 1.6.1 and solaris version is 1.6.0. I use RMySQL_0.5-0 > (on solaris) > and RODBC 1.0-1 on PC to connect to MySQL. The PC version took about 65 > mins. to run > wheras the Solaris (SunOS 5.7) version took 375 mins. (> 6 hrs). R and > RMySQL are > resident on the same host (solaris) as the MySQL database. > > Can experts on the list please throw some light as how to improve the > speed with which RMySQL queries can be processed ? > > RMySQL database access is done as follows: > ------------------------------------------- > library(RMySQL) # 1 > con <- dbConnect( ... ) # 2 > ... > rs <- dbSendQuery(con,qry) # 3 > rdat <- fetch(rs,n=10000) # 4 > ... > dbDisconnect(con) # 5 > ------------------------------------------- > > lines #3 and #4 are repeated about 10000 times in the script. > > Thanks in advance for any help. > Sukhaswami Malladi > > > *************************************************************************** > The contents of this communication are intended only for the addressee and > may contain confidential and/or privileged material. If you are not the > intended recipient, please do not read, copy, use or disclose this > communication and notify the sender. Opinions, conclusions and other > information in this communication that do not relate to the official > business of my company shall be understood as neither given nor endorsed by > it. > *************************************************************************** > > ______________________________________________ > [EMAIL PROTECTED] mailing list > http://www.stat.math.ethz.ch/mailman/listinfo/r-help > -- Brian D. Ripley, [EMAIL PROTECTED] Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595 ______________________________________________ [EMAIL PROTECTED] mailing list http://www.stat.math.ethz.ch/mailman/listinfo/r-help
