[Virtuoso-users] Transitivity SQL is memory hungry

2012-08-02 Thread Aris Setyawan
Hi All, I have done several test in v.615, with transitivity SQL to find routings between one point to another point. But, unfortunately, that v.615 suffered in insufficient memory allocation after I add more data to the routing table. This is the error: "Message: TN...: Exceeded 1 bytes

[Virtuoso-users] multiple accumulator in user defined aggregate function

2012-05-07 Thread Aris Setyawan
Hi, In the documentation, it is said that we can have multiple accumulator: "The acc_procedure must have at least one inout parameter, one or more parameters of any sort and must return nothing. It should get the previously calculated value of the "accumulator" from its first parameter, calculate

[Virtuoso-users] SQL transitivity features usage

2012-04-23 Thread Aris Setyawan
Hi, >From this link http://docs.openlinksw.com/virtuoso/transitivityinsQL.html , explained that the syntax for transitivity is: transitive_decl ::= TRANSITIVE [, ...] trans_opt :: = | T_MIN (INTNUM) | T_MAX (INTNUM) | T_DISTINCT | T_EXISTS | T_NO_CYCLES