On 23/12/14 19:21, Jose Noel Mendoza Bastidas wrote:
Hi,
Hi
I was measuring the execution time of some queries using different optimizers that provides MonetDB (minimal, default, no_mitosis, sequential and recycler).
Now I want to measure these times but using user-defined optimizer pipeline
For this I am testing with the following command:
MonetDB Septemberoptpipe='optimizer.inline();optimizer.remap();optimizer.deadcode();optimizer.multiplex();optimizer.garbageCollector();' tesisdb ^^^^^^ ^^^^^^^^^^^^^^^ unkown command line arguments, perhaps a local script?
mclient -d demo Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased) Database: MonetDB v11.20.0 (unreleased), 'mapi:monetdb://vienna.ins.cwi.nl:50000/demo' Type \q to quit, \? for a list of available commands auto commit mode: on sql>set optimizer='optimizer.inline();optimizer.remap();optimizer.deadcode();optimizer.multiplex();optimizer.garbageCollector();'; operation successful (0.837ms) sql>
sets the optimizer pipe for the current client session. regards, Martin
According to the documentation that would be equivalent to using minimal_pipe, the fact is that when I use the expressed command above and run the query throws me the following error:
Function '@ 7 ?.' not defined
I wonder if someone has happened something like this or have any idea how to create different pipes to those provided by the system
Thanks in advance
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list