search

architolk / Linked-Data-Theatre

The Linked Data Theatre is a platform for an optimal presentation of Linked Data
GNU General Public License v3.0
38 stars 21 forks source link

table appearance goes no further dan 10000 #75

Closed GeraldGrootRoessink closed 6 years ago

GeraldGrootRoessink commented 6 years ago

A sparql result never goes beyond 10000 records. Even if the query explicitly specifies a higher limit. Is there some way to configure a higher limit?

TallTed commented 6 years ago

This limit is set by the ResultSetMaxRows setting in the Virtuoso INI file.

Its effect is seen only on the HTTP/S-based SPARQL endpoints; this setting does not impact SPASQL a/k/a SPARQL-in-SQL queries executed through ODBC, JDBC, ADO.NET, OLE DB, or other data connections.

Alternatively, you can use LIMIT/OFFSET (with ORDER BY) clauses to step through the full result set when it exceeds the ResultSetMaxRows setting.