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.crowt...@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 <e...@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@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@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. ______________________________________________ R-help@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.
