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 <[EMAIL PROTECTED]> > To: SOL ZADEH <[EMAIL PROTECTED]> > Cc: [email protected] > 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 > > [email protected] > <mailto:[email protected]> > > 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: > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/monetdb-developers >
------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
