Hi, where can I find some MAL samples? There are a large collection of MAL test scripts available in
Henri Asseily wrote: the source distribution. That would inspire most. Aside from these example, there is the MAL documentation.
I'm trying to do very simple things such as storing and loading a bat, joining bats and iterating through them.
I know I can do an explain on SQL statements, but those seem incredibly convoluted even for a simple select on a single column, which should be a straightforward sql.bind(,,,0) with follow-through sql.resultSet and sql.rsColumn if I understand this whole business correctly. Instead, it's doing a couple of algebra kunion and kdifference that I don't understand.
The manual contains an appendix with a short description of the operators.
I'm not trying to do MAL algebra on a SQL database, I'm trying to go 100% MAL and hand-coding some simple joins and iterators.
Iterators should hardly be needed for most algebraic plans.
I would have gone SQL all the way, but I need to iterate through a bat and calculate a result for each row, then return that sorted new bat based on the result. Doing it in SQL is overly complicated when some simple MAL statements should do the job.
you pay by complexity and may win a little. You may have a look at the TRACE SELECT * ,... to see if your expectation of loss of performance is correct to go for a MAL specific solution. Iteration on tuple level in MAL is still not fast ( <1 microsec/instr) regards, Martin
Thanks.
--- Henri Asseily henri.tel
------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users