Hi

MonetDB SQL supports stored procedures. http://www.monetdb.org/Documentation/Manuals/SQLreference/Procedures However, recoding in that way will not give you more parallelism. By default all queries are already ran in parallel against all cores of your machine.

regards, Martin On 6/19/11 4:03 AM, Michael Kusber wrote:

Hi,

is it possible to achieve the following using SQL stored procedures à la "CREATE PROCEDURE XYZ"? I want to write a function that iterates over a table and adds 2 on a certain attribute. i am realizing that i could do this by an UPDATE, but I wanted to see, whether it would be executed more parallel inside a stored procedure. Is there a way of formulating this in a procedure? do i need to define a function in MAL? would this result in more parallel execution?

thanks, michael

---

EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users