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.
> ***************************************************************************
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> http://www.stat.math.ethz.ch/mailman/listinfo/r-help
>
--
Brian D. Ripley, ripley at stats.ox.ac.uk
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