Hi Bharath,

There is the Virtuoso "MaxMemPoolSize" which can be set in the "[Parameters]" 
section of the INI file to increase the pool size or set to 0 to make it 
unlimited as detailed at:

        http://docs.openlinksw.com/virtuoso/dbadm.html

Do not this then mean there must be sufficient memory available on the machine 
for the memory being allocated to the pool ...

Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc.      //              http://www.openlinksw.com/
Weblog   -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter  -- http://twitter.com/OpenLink
Google+  -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers

On 25 Mar 2013, at 13:51, Bharath V <[email protected]> wrote:

> Hi All,
>     I am doing the Transitive SPARQL Query Options query to find how two 
> nodes are connected what graphs are involved in the connection. 
> I get  memory error. Below are the error & query -
> 
> Error :
>     SQLState: 42000
> Message: TN...: Exceeded 100000000 bytes in transitive temp memory.  use 
> t_distinct, t_max or more T_MAX_memory options to limit the search or 
> increase the pool
>  
> Query:
> SELECT ?link ?predicate ?step ?path
> WHERE {
> { SELECT ?subject ?predicate ?object ?graph 
> WHERE {
> graph ?graph {?subject ?predicate ?object .} . 
> 
> }} 
>  OPTION (TRANSITIVE, T_DISTINCT, T_IN(?subject), T_OUT(?object), 
> T_NO_CYCLES,T_MIN(0), T_MAX(3), T_STEP (?subject) AS ?link, T_STEP 
> ('path_id') AS ?path, T_STEP ('step_no') AS ?step, T_DIRECTION 3) .
> Filter (?subject = <X> && ?object = <Y>)
> }
> 
> If i remove the predicate i get the results. But i require prediate for 
> further processing.  Please let me know 
> 
> 1. How the increase the pool/memory ?
> 2. Is this option available in "virtuoso.ini" . If not  can we change in the 
> source and compile it. If we change in code, are there any repercussions of 
> changing in source code.
> 3. Can we expect this option in "virtuoso.ini" further releases.
>  
> Thank You,
> Bharath
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_d2d_mar_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Attachment: smime.p7s
Description: S/MIME cryptographic signature

------------------------------------------------------------------------------
Own the Future-Intel&reg; Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game 
on Steam. $5K grand prize plus 10 genre and skill prizes. 
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to