[Monetdb-developers] tables/databases simultaneous updates & extended-stored-procedures

Martin Kersten Martin.Kersten at cwi.nl
Sat Jul 19 15:22:16 CEST 2008


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 <Niels.Nes at cwi.nl>
> To: SOL ZADEH <solzadeh at yahoo.com>
> Cc: monetdb-developers at lists.sourceforge.net
> Sent: Saturday, July 19, 2008 8:49:55 AM
> Subject: Re: [Monetdb-developers] tables/databases simultaneous 
> updates & extended-stored-procedures
>
> On Fri, Jul 18, 2008 at 05:13:54PM -0700, SOL ZADEH wrote:
> >    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
> 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=/>
> > _______________________________________________
> > Monetdb-developers mailing list
> > Monetdb-developers at lists.sourceforge.net 
> <mailto:Monetdb-developers at 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>  e-mail: 
> Niels.Nes at cwi.nl <mailto:Niels.Nes at 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=/
> ------------------------------------------------------------------------
>
> _______________________________________________
> Monetdb-developers mailing list
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers
>   





More information about the developers-list mailing list