Re: [MonetDB-users] multiple result sets
Fabian, thanks for your response. i did try it. as far as i can see, stored procedures cannot return result set at all... i hoped to get an official verification for my findings. and maybe any work around. about the network traffic: the result would be the same with or without stored procedure, but the request would be much smaller. sending a request like: "call sp1(x,y,z);" is much smaller than a very large bulk of statements. of course, the more critical point is to avoid unnecessary re-compilation of a large and complex bulk of statements, that should be able to execute many times during a single second. in mssql, and mysql, procedures do able to return multiple result sets. i don't know what is the standard sql2003 about it. do you think it worth a bug\feature report? thanks, again.
On 18-03-2010 19:41:50 +0200, אייל wrote:
i did try it. as far as i can see, stored procedures cannot return result set at all... i hoped to get an official verification for my findings. and maybe any work around.
about the network traffic: the result would be the same with or without stored procedure, but the request would be much smaller. sending a request like: "call sp1(x,y,z);" is much smaller than a very large bulk of statements. of course, the more critical point is to avoid unnecessary re-compilation of a large and complex bulk of statements, that should be able to execute many times during a single second.
Ok, now I see.
in mssql, and mysql, procedures do able to return multiple result sets. i don't know what is the standard sql2003 about it. do you think it worth a bug\feature report?
I think a feature request for this is useful in any case, because it seems others are doing this as well.
Fabian Groffen wrote:
On 18-03-2010 19:41:50 +0200, אייל wrote:
i did try it. as far as i can see, stored procedures cannot return result set at all... i hoped to get an official verification for my findings. and maybe any work around.
about the network traffic: the result would be the same with or without stored procedure, but the request would be much smaller. sending a request like: "call sp1(x,y,z);" is much smaller than a very large bulk of statements. of course, the more critical point is to avoid unnecessary re-compilation of a large and complex bulk of statements, that should be able to execute many times during a single second.
Ok, now I see. You don't have to worry about re-compilation. MonetDB automatically turns queries into query templates, factoring out the constants. So, if x,y,z are scalar values you pay the optimization step once.
in mssql, and mysql, procedures do able to return multiple result sets. i don't know what is the standard sql2003 about it. do you think it worth a bug\feature report? We follow the standard as much as possible, which does not provide for this feature.
regards, Martin
I think a feature request for this is useful in any case, because it seems others are doing this as well.
------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (3)
-
Fabian Groffen -
Martin Kersten -
אייל