Hi Niels,
Thanks for your answers.
On Saturday 15 September 2007 14:53, Niels Nes wrote:
It seems your benchmark is mostly measuring the communication overhead of both database systems. Indeed thats where MySql excels.
Are you saying the MySQL communication overhead is generally lower (eg more efficient protocol and/or client libs) or just that their PHP extension is better optimized (for this use case)? Indeed the PHP extension of MySQL seems very optimized. Simply wrapped our default client library (libMapi) and didn't spend time on optimizing this. So I'm not sure were the php extention of MonetDB stands.
Do you know if MonetDB supports unix domain sockets, as postgres and mysql do? In deed we do support unix named sockets (didn't test it recently though) on
On Sat, Sep 15, 2007 at 04:05:07PM -0600, Dan Libby wrote: the Mapi layer. I guess the php extention doesn't however.
On a local machine, that should prover faster.
Add some more complexitity to the queries (joins and/or aggregates) and MonetDB should behave just fine. Maybe even changing your query from
"select col1 from big_table where col1 = $i";
into
"select count(*) from big_table where col1 = $i";
I'll try both an aggregate and a join, separately. thanks for the suggestion.
may allready change the picture. For sure your big_table isn't that big.
Do you mean "not big" in terms of number of rows, or columns, or both? Both.
With these very simple select queries, my expectation would be that I would see the same linear trend if the number of rows were 10000 or 10,000,000. This completely depends on the amount of physical memory and in case of Mysql also on the sizes of your io buffers. In such small sizes (number of rows) the overhead of the protocol is a much bigger part of the total cost then with larger database sizes.
Niels
regards,
-- Dan Libby
Open Source Consulting San Jose, Costa Rica http://osc.co.cr phone: 011 506 223 7382 Fax: 011 506 223 7359
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl