Re: [Virtuoso-users] Error SR078: The result set is too long, must limit result for at most 2097151 rows

2018-09-06 Thread Peter F. Patel-Schneider
I had already bumped into the limit that you found. This is a second limit, also mentioned in that thread. This limit is 2^(24-3) for modern CPUs, as mentioned by iv-an-ru. It is this limit that I'm bumping into. Unfortunately, this limit appears to be something that can't be modified by simply

Re: [Virtuoso-users] Error SR078: The result set is too long, must limit result for at most 2097151 rows

2018-09-06 Thread Hugh Williams
Hi Peter, You can get around this by using LIMIT / OFFSET in the query or by using one of the SQL interfaces ie ODBC / JDBC / ADO.Net etc as was indicated in the git issue (https://github.com/openlink/virtuoso-opensource/issues/700) and even using our Jena/Sesame Provider which use JDBC under t