[R] Rprof fails in combination with RMySQL

[Thieme, Lutz]

Hello Bogdan, 

thanks for you reply. My MySQL is always optimized oustide 
from R (but many thanks for the interesting link!). 
I'm very sure that I have to optimize the R code which uses 
the data from my queries for calculations. To get more in-
formation which R function is the main speed limiter I tried 
Rprof. 
Because I'm always opening and closing the connection for every 
query I have never opened more than one connection. 
And again: The same R code runs without Rprof stable since weeks
multiple times a day. I can exclude by 99% that the error comes 
from the database. Maybe it comes from large number of opening
closing cycles?...

Regards,

Lutz



> -----Original Message-----
> From: bogdan romocea [mailto:br44114 at gmail.com]
> Sent: Thursday, July 21, 2005 5:05 PM
> To: Thieme, Lutz
> Cc: R-help at stat.math.ethz.ch
> Subject: RE: [R] Rprof fails in combination with RMySQL
> 
> 
> 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
> >
> 
>