AKSW/OntoWiki — Issue #47: Big Files gives sql/sparql error
Author: JanDe
Created: 2012-03-08 15:17:44+00:00
State: open

When using big files as model,

- An sql error is returned when going to the history. : Expression recursion is too deep () in query:

Solved by changing:
model = \'' . $graphUri . '\' AND ( resource = \'' . implode ('\' OR resource = \'' ,$resources) .
INTO
model = \'' . $graphUri . '\' AND ( resource IN (\'' . implode ('\' , \'' ,$resources) . '\' ))

- An SPARQL error is returned when you want to see all instances.

Solved by changing the list of sameTerm in the sparql query to a construction like this one:

SELECT DISTINCT ?resourceUri ?__TYPE WHERE{?resourceUri ?__TYPE. FILTER(?resourceUri IN( , , ))}

(This also leads to an performance gain if you remove OPTIONAL in the query also.)