Hi You are using SQL as an imperative programming language and this function, if essential, should be considered to be implemented as a C or Python bulk UDF. If you stick to the SQL variant, you can start analyzing the cost of this function using the profiling tools.
https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/QueryTiming
"A detailed time of an SQL query can be obtained with prepending the query with the modifier TRACE. It will produce a queryable table with a break down of all relational algebra operations (see TRACE command). The profiling tools stethoscope and tomograph provide further details for those interested in the inner working of the system. It provides a hook to many system parameters, e.g. input/output, CPU cycles, and threads' activities."
Success, Martin
On 22/11/2016 23:03, Ariel Abadi wrote:
Hi! We are trying to create a couple of functions in Monet. Every function we create has a terrible bad performance.
Can someone help me to find out what Im doing wrong ? Here is the function
CREATE FUNCTION sb_glob.camelcase(input VARCHAR(500)) RETURNS VARCHAR(500) begin DECLARE len INT; DECLARE i INT; SET len = CHAR_LENGTH(input); SET input = LOWER(input); SET i = 0; WHILE (i < len) DO SET input = CASE WHEN ((SUBSTR(input,i,1) = ' ' OR SUBSTR(input,i,1) = '-' OR i = 0) AND (i < len)) THEN (LEFT(input,i) || UPPER(SUBSTR(input,i + 1,1)) || RIGHT(input,len - i - 1)) ELSE input END; SET i = i + 1; END WHILE; RETURN input; END
Thks in advance!
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list