Re: [MonetDB-users] [Monetdb-developers] tables/databases simultaneous updates & extended-stored-procedures

SOL ZADEH wrote:

Thanks Martin; let me explain better:

if table update are too costly (slow etc) then could try insertion instead (having/including the timestamps as an index) providing the server can cope with very frequent table insertions.

Is there any benchmark tests in relation to table insertions?

you can have a look at the TPCH loading figures. http://monetdb.cwi.nl/projects/monetdb//SQL/Benchmark/TPCH/ I have no hard figures in my head, but the DVD store benchmark we ran 2 years back came out directly after MySQL for high-volume business transactions. http://monetdb.cwi.nl/projects/monetdb/SQL/Benchmark/DVDstore/index.html so it all depends what you consider costly/slow.

Regarding :

...

...

Concurrent transactions can freely read a consistent copy of the database. does this mean "dirty reads" ?

no, only consistent reads

Regards

----- Original Message ---- From: Martin Kersten To: SOL ZADEH Cc: Niels Nes ; monetdb-developers@lists.sourceforge.net Sent: Saturday, July 19, 2008 2:22:16 PM Subject: Re: [Monetdb-developers] tables/databases simultaneous updates & extended-stored-procedures

SOL ZADEH wrote:

...

Thanks Neils for your prompt reply.

Is there a quantified limitation on "insertions" on scenarios I mentioned below (multiple tables/database)? I.e. Does very frequent insertions on 2 or more tables (on same database or other database on the same server) in any way effect the performance of the other queries (select,insert,update) on the "same" or "other" tables (i.e. is parallel processing possible & locking performance etc). Regards

Trying to interpret you question what it means. MonetDB does not lock tables or databases during update. Concurrent transactions can freely read a consistent copy of the database. All interference comes from sharing the same CPU, memory and IO channels.

...

----- Original Message ---- From: Niels Nes mailto:Niels.Nes@cwi.nl> To: SOL ZADEH mailto:solzadeh@yahoo.com> Cc: monetdb-developers@lists.sourceforge.net

mailto:monetdb-developers@lists.sourceforge.net

...

Sent: Saturday, July 19, 2008 8:49:55 AM Subject: Re: [Monetdb-developers] tables/databases simultaneous updates & extended-stored-procedures

...

Hi

I have a couple of questions and really appreciate if any one could answer them or instruct me to the relevant forum topics:

1- what is the limitations (speed, threshold etc) on simultaneous tables /databases update i.e. via multiple odbc connection lets say (also any other faster API to interface with the MonetDB ?) MonetDB research concentrated mostly in low update/high query loads. The update implementation is still quite capable, but no reall performance experiments on updates have been conducted. Next to odbc we have mapi and jdbc APIs available.

2- Is there a way to have the triggers to generate real-world (non-db) events i.e. similar to the Extended Stored Procedure in SqlServer or the way Oracle allows you to run Java code inside the stored procedures. MonetDB can be extended using C-code and that code could be run within

On Fri, Jul 18, 2008 at 05:13:54PM -0700, SOL ZADEH wrote: the triggers.

Niels

...

Thanks

...

-------------------------------------------------------------------------

...

...

This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ http://moblin-contest.org/redirect.php?banner_id=100&url=/ <http://moblin-contest.org/redirect.php?banner_id=100&url=/ http://moblin-contest.org/redirect.php?banner_id=100&url=/> _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net mailto:Monetdb-developers@lists.sourceforge.net mailto:Monetdb-developers@lists.sourceforge.net> https://lists.sourceforge.net/lists/listinfo/monetdb-developers

--

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 http://www.cwi.nl/%7Eniels http://www.cwi.nl/%7Eniels e-mail: Niels.Nes@cwi.nl mailto:Niels.Nes@cwi.nl mailto:Niels.Nes@cwi.nl>

------------------------------------------------------------------------

...

This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in

------------------------------------------------------------------------- the world

...

http://moblin-contest.org/redirect.php?banner_id=100&url=/ http://moblin-contest.org/redirect.php?banner_id=100&url=/ ------------------------------------------------------------------------

_______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net mailto:Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers