On Mon, Nov 26, 2007 at 09:37:48AM +0100, Markus Gritsch wrote:
Please look at my e-mail again. MonetDB outperforms MySQL in my case only when *not* using the index i.e. querying over the "entries" of *all* "acts", which is very good. Unfortunately, as already posted in my original e-mail, in the common case (in my application) of querying only over the "entries" of the *open* "acts", MonetDB is 3x slower than MySQL.
Sorry, my fault. I read MySQL: 0.26 Seconds MonetDB: 0.8 Seconds as MySQL: 2.6 Seconds MonetDB: 0.8 Seconds (... wishful thinking ... ? ;-)) Stefan -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |