Re: [R] Rprof fails in combination with RMySQL

From: bogdan romocea <br44114_at_gmail.com>
Date: Fri 22 Jul 2005 - 01:05:25 EST


I think you're barking up the wrong tree. Optimize the MySQL code separately from optimizing the R code. A very nice reference about the former is http://highperformancemysql.com/. Also, if possible, do everything in MySQL.
hth,
b.

> -----Original Message-----
> From: Thieme, Lutz [mailto:lutz.thieme@amd.com]
> Sent: Thursday, July 21, 2005 10:11 AM
> To: Rhelp (E-mail)
> Subject: [R] Rprof fails in combination with RMySQL
>
>
> Dear R community,
>
> I tried to optimized my R code by using Rprof. In my R code
> I'm using MySQL
> database connections intensively. After a bunch of queries R
> fails with the
> following error message:
> Error in .Call("RS_MySQL_newConnection", drvId, con.params,
> groups, PACKAGE = .MySQLPkgName) :
> RS-DBI driver: (could not connect mylogin@mydatabase
> on dbname "myDB"
>
> Without the R profiler this code runs very stable since weeks.
>
> Do you have any ideas or suggestions?
>
> I tried the following R versions:
> ___________________________
> platform i386-pc-solaris2.8
> arch i386
> os solaris2.8
> system i386, solaris2.8
> status
> major 1
> minor 9.1
> year 2004
> month 06
> day 21
> language R
> ___________________________
> platform sparc-sun-solaris2.8
> arch sparc
> os solaris2.8
> system sparc, solaris2.8
> status
> major 2
> minor 1.1
> year 2005
> month 06
> day 20
> language R
> ___________________________
> platform sparc-sun-solaris2.8
> arch sparc
> os solaris2.8
> system sparc, solaris2.8
> status
> major 1
> minor 9.1
> year 2004
> month 06
> day 21
> language R
>
>
> Thank you in advance and kind regards,
>
> Lutz Thieme
> AMD Saxony/ Product Engineering AMD Saxony Limited
> Liability Company & Co. KG
> phone: + 49-351-277-4269 M/S E22-PE,
> Wilschdorfer Landstr. 101
> fax: + 49-351-277-9-4269 D-01109 Dresden, Germany
>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide!
> http://www.R-project.org/posting-guide.html
>



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Fri Jul 22 01:41:12 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:33:55 EST