Hi Ward Are you sure this worked with a previous version and if so which version. Might the size of the result set increased since then ?
You can increased the available memory pool size by increasing the following params in the [Parameters] section of your virtuoso.ini file: NumberOfBuffers = 300000 MaxDirtyBuffers = 240000 MaxCheckpointRemap = 300000 As detailed at: http://docs.openlinksw.com/virtuoso/dbadm.html#ini_Parameters I would suggest doubling them to start off with and increase accordingly until the query runs. Best Regards, Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers On 21/02/2008 14:33, "Ward Blondé" <wa...@psb.ugent.be> wrote: > > > Hello, > > In VOS 5.0.5 I tried the following query: > > prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#> > prefix > uri001:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_C0000043> > prefix uri002:<http://www.cellcycleontology.org/ontology/rdf/CCO#Definition> > prefix > uri003:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_C0000446> > prefix uri004:<http://www.cellcycleontology.org/ontology/rdf/CCO#Definition> > prefix > uri005:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_C0000505> > prefix uri006:<http://www.cellcycleontology.org/ontology/rdf/CCO#Definition> > prefix > uri007:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_C0000793> > prefix uri008:<http://www.w3.org/2000/01/rdf-schema#comment> > prefix > uri009:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_C0001883> > prefix uri010:<http://www.cellcycleontology.org/ontology/rdf/CCO#Definition> > prefix > uri011:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_C0001980> > prefix uri012:<http://www.cellcycleontology.org/ontology/rdf/CCO#Definition> > prefix > uri013:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_C0002040> > prefix uri014:<http://www.cellcycleontology.org/ontology/rdf/CCO#Definition> > prefix > uri015:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_P0000103> > prefix uri016:<http://www.cellcycleontology.org/ontology/rdf/CCO#Definition> > prefix > uri017:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_P0000103> > prefix uri018:<http://www.cellcycleontology.org/ontology/rdf/CCO#synonym> > prefix > uri019:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_P0000103> > prefix uri020:<http://www.cellcycleontology.org/ontology/rdf/CCO#synonym> > select * > from <http://www.cellcycleontology.org/ontology/rdf/CCO> > where { > optional{uri001: rdf:type ?type001}. > optional{uri002: rdf:type ?type002}. > optional{uri003: rdf:type ?type003}. > optional{uri004: rdf:type ?type004}. > optional{uri005: rdf:type ?type005}. > optional{uri006: rdf:type ?type006}. > optional{uri007: rdf:type ?type007}. > optional{uri008: rdf:type ?type008}. > optional{uri009: rdf:type ?type009}. > optional{uri010: rdf:type ?type010}. > optional{uri011: rdf:type ?type011}. > optional{uri012: rdf:type ?type012}. > optional{uri013: rdf:type ?type013}. > optional{uri014: rdf:type ?type014}. > optional{uri015: rdf:type ?type015}. > optional{uri016: rdf:type ?type016}. > optional{uri017: rdf:type ?type017}. > optional{uri018: rdf:type ?type018}. > optional{uri019: rdf:type ?type019}. > optional{uri020: rdf:type ?type020}. > } > > The aim is to post-process the answer of any other random query > programmatically, and to look what are the types of the uri's. But I get > this error-message: > ..... Error SQ200: The memory pool size 10495344 reached the limit > 10485760 bytes, try to increase the MaxMemPoolSize ini setting. > > Is it because I used to many prefixes? I thought this query worked > before the change to 5.0.5. It still seems to work with less uri's. > > thanks, > > Ward > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
