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:[EMAIL PROTECTED] > 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 [EMAIL PROTECTED] > 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