[R] SQL vs R

Bert Gunter gunter.berton at gene.com
Tue May 6 17:23:26 CEST 2014


I believe this discussion should be taken offlist as it no longer
seems to be concerned with R.

-- Bert Gunter

Bert Gunter
Genentech Nonclinical Biostatistics
(650) 467-7374

"Data is not information. Information is not knowledge. And knowledge
is certainly not wisdom."
H. Gilbert Welch




On Tue, May 6, 2014 at 7:40 AM, Peter Crowther
<peter.crowther at melandra.com> wrote:
> The dataset is not large by database standards.  Even in mySQL - not known
> for its speed at multi-row querying - the queries you describe should
> complete within a few seconds on even moderately recent hardware if your
> indexes are reasonable.
>
> What are your performance criteria for processing these queries, and how
> have you / your team optimised the relational database storage?
>
> Cheers,
>
> - Peter
> --
> Peter Crowther, Director, Melandra Limited
>
>
> On 6 May 2014 15:32, Dr Eberhard Lisse <el at lisse.na> wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> Exactly,
>>
>> which is why I am looking for something faster :-)-O
>>
>> el
>>
>> on 2014-05-06, 15:21 David R Forrest said the following:
>> > It sounds as if your underlying MySQL database is too slow for your
>> > purposes.  Whatever you layer on top of it will be constrained by
>> > the underlying database.  To speed up the process significantly,
>> > you may need to do work on the database backend part of the
>> > process.
>> >
>> > Dave
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.12 (Darwin)
>> Comment: GPGTools - http://gpgtools.org
>> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
>>
>> iQCVAwUBU2jyd1sF2hmmSQy5AQJVPQP+MnrEkXLY9PK+N2CB+maySkRKhEXcWTUA
>> KNOQnTDaYl3wnRZKg8y1wiZbLFA8tWsKpXPv91phDZ2000MTbv7SbnpBXthSzbAn
>> clEOniQqRcXci1Q2Qjd+mH0YxyA6XpNvBnBIlbxPsQbObwjK+dKl7/cna1oZKUhW
>> 6aytsFtPZTI=
>> =zepY
>> -----END PGP SIGNATURE-----
>>
>> ______________________________________________
>> R-help at r-project.org mailing list
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide
>> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
>         [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.



More information about the R-help mailing list