Re: AW: Insert/update value manipulation

Hi Thomas, I would view this file as a starting point for the path the data follows from the sql layer down to disk. I guess the answer to your question, if UDFs are a good idea, depends on the specific research questions you are investigating and which components' performance you are measuring. I think that UDFs could potentially be a good initial approach, especially if you are not familiar with the codebase, but again, it depends very much on your research goal. Best regards, Panos. Schediwy @ 2018-07-11 14:05 GMT:

Hi Panos,

thank you for your hints. I'll take a look for the file. I haven't found that file before.

Well UDFs may help, but I want to implement some additional compression schemas for some performance research. So do you think UDFs are still a good idea to measure the performance between compressed and uncompressed data?

Best regards Thomas

-----Ursprüngliche Nachricht----- Von: developers-list Im Auftrag von Panagiotis Koutsourakis Gesendet: Mittwoch, 11. Juli 2018 12:19 An: Communication channel for developers of the MonetDB suite. Betreff: Re: Insert/update value manipulation

Hi Thomas,

Take a look at the file sql/server/rel_updates.c but before you dive into the internals of the sql layer, think if you can accomplish your goals in a simpler way (with UDFs for instance: https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/UserDefinedFuncti..., https://www.monetdb.org/node/437 and https://www.monetdb.org/blog/embedded-pythonnumpy-monetdb).

Best regards, Panos.

Schediwy @ 2018-07-10 13:44 GMT:

...

Hi there,

I am looking for the function where I can manipulate the values from an insert or update statement.

For now, I am using a Solaris 10 system. But I havent found the functions where the insert or update will get done. I have looked trogh the files stream.c, mapi.c and mclient.c. But everytime I tried to change the values in the variables nothing happend.

Can somebody please help me?

Thanks in advise

Thomas

---

developers-list mailing list developers-list@monetdb.org https://www.monetdb.org/mailman/listinfo/developers-list _______________________________________________ developers-list mailing list developers-list@monetdb.org https://www.monetdb.org/mailman/listinfo/developers-list