Re: [Virtuoso-users] creating indexes with Virtuoso 7.0.0

Hi Hugh, Reason #1: The Virtuoso tuning guide suggested: "If predicate and graph are given but subject is not, then it is sometimes useful to add: CREATE BITMAP INDEX RDF_QUAD_PGOS ON DB.DBA.RDF_QUAD (G, P, O, S) PARTITION (O VARCHAR (-1, 0hex));" The instructions did not indicate for this

Re: [Virtuoso-users] creating indexes with Virtuoso 7.0.0

Hi Erich, Why are you creating these additional indexes and if you did were the defaults dropped first ? What does the the following query return: STATISTICS DB.DBA.RDF_QUAD; Which should return a list of indexes on the RDF_QUAD table ... As indicated in the performance tuning guide th

Re: [Virtuoso-users] Strange use of indices in Virtuoso 7.0.0

Hi Nicola, What does the following report as the version of your build: ./virtuoso-t -? and for your build tree what does the "git status" command return when run against your build tree, so we can confirm which build is being used ... Best Regards Hugh Williams Professional Services O

Re: [Virtuoso-users] Path query crashes virtuoso 7.00.3203

Hi Jerven, I have downloaded the /taxonomy.rdf.gz dataset and installed, but have not been able to recreate this problem using a commercial or open source Virtuoso build: $ ./bin/virtuoso-t -? -bash: ./bin/virtuoso-t: No such file or directory Hughs-MacBook-Pro-355:database hwilliams$ ../bin/vir

[Virtuoso-users] creating indexes with Virtuoso 7.0.0

Either way, I get the following error when starting my bulk load: *** glibc detected *** virtuoso-t: double free or corruption (out): 0x7f6b710f2000 *** Segmentation fault - Erich Erich Bremer http://www.ebremer.com The default schema as per the below URL is: CREATE DISTINCT NO PRIM

[Virtuoso-users] creating indexes with Virtuoso 7.0.0

The default schema as per the below URL is: CREATE DISTINCT NO PRIMARY KEY REF BITMAP INDEX RDF_QUAD_SP ON RDF_QUAD (S, P) PARTITION (S INT (0hex00)); CREATE BITMAP INDEX RDF_QUAD_POGS ON RDF_QUAD (P, O, G, S) PARTITION (O VARCHAR (-1, 0hex)); CREATE DISTINCT NO PRIMARY KEY RE

[Virtuoso-users] creating indexes with Virtuoso 7.0.0

Hi, I tried creating the index as per the page: http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFPerformanceTuning CREATE BITMAP INDEX RDF_QUAD_PGOS ON DB.DBA.RDF_QUAD (G, P, O, S) PARTITION (O VARCHAR (-1, 0hex)); which successfully creates via ISQL (seemingly), but

Re: [Virtuoso-users] Strange use of indices in Virtuoso 7.0.0

Hi Hugh, the rc2 version we used is 48f0ef879b913c5d3b306c1f83390079c5416fe6 , downloaded from . I also noticed that, if I load the same data on 7.0.0 from scratch, the query runs "fast". Is there maybe a problem in how indices are interpreted in t

Re: [Virtuoso-users] Path query crashes virtuoso 7.00.3203

The SPARQL update approach does not immediately crash if I change the following settings. TransactionAfterImageLimit = 5

[Virtuoso-users] Path query crashes virtuoso 7.00.3203

Hi Virtuoso devs, The following queries crash the virtuoso server. Version 07.00.3203-pthreads for Linux as of Oct 11 2013 This is a build from the develop/7 branch commit 0bc9bc2dbd846a58d47bacee60b3a236a56abd4a In each of these cases I first turn do log_enable(0); With the aim turn this back