[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 ?)
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. Thanks
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=/ _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
participants (2)
-
Niels Nes
-
SOL ZADEH