I read sql_optimizer setting in monetdb5.conf ,and default setting is:
sql_optimizer=default_pipe
default_pipe=inline,remap,evaluate,costModel,coercions,emptySet,aliases,mitosis,mergetable,deadcode,commonTerms,joinPath,reorder,deadcode,reduce,garbageCollector,dataflow,history,multiplex
so there are many optimizer,but why when i debug MonetDB,and dump the mal of
my sql statement,but i can't find the optimizer mal ,and don't enter the
optimizer? like there are no optimizer,
2010/8/11 Stefan Manegold
Yes, if you write MAL "by hand" (or have some program create it) that does explicitly call a MAL optimizer, that MAL optimizer is indeed used to optimize the MAL code according to its very purpose.
Stefan
On Wed, Aug 11, 2010 at 03:49:47PM +0800, kun ren wrote:
It is only used by SQL? and how to designation the optimiser？but when I write MAL,for example, i:=0; b:= "done"; barrier go:= true; c:=i+1; d:="step"; v:=d; io.print(v); i:=c; redo go:= i<2; exit go; io.print(b); optimizer.aliasRemoval();
the last optimizer.aliasRemoval() is used for optimizing?
2010/8/11 Fabian Groffen
Recently,I am intersting in MAL optimize，and have read the manual of
On 11-08-2010 15:25:15 +0800, kun ren wrote: the
MAL optimize, but it is so long, Possible if we want to use mal optimize ,we must degignation the optimize consideration, such as alias removal, constant expression,join path optimizer;And then I dedug the MonetDB,but default it don't use any optimize.so what do you think about the mal optimize?
It is only used when you use SQL. The sql_optimizer setting in monetdb5.conf controls which optimisers are run, which by default are quite a few.
This SF.net email is sponsored by
Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
------------------------------------------------------------------------------
This SF.net email is sponsored by
Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev
_______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4199 |