RMySQL connections speed
Hi, The problem with long delays turned out to be in the coercion function as() that I use to coerce connection and result objects into integers (the underlying C codes uses integers as handles). Thanks to John Chambers for quickly fixing the problem (see his earlier posting today in r-devel). -- David
Laurent Faisnel wrote:
Hi, I've just tried your new function lean.exec, and I'mvery surprise such a short code can have so devastating effects ! The result (at least, after the first tests) is fantastic. The request takes just an instant (unix.time: less than 0.01 sec.), instead of the 2 seconds dbGetQuery used to take. If this is confirmed you brought very good a piece of news to me, thanks ! But how do you explain there is such a speed difference between the two functions ? Keep me informed of any further test you could make. Laurent