[R] Rprof fails in combination with RMySQL

[bogdan romocea]

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 at 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 at 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 at 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
>