[R-sig-DB] Re: RMySQL connections speed

[David James]

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