On 4/30/15 12:37 PM, Paul Houle wrote:
Something that is more scalable than OFFSET is to compare on keys, so if you ORDER BY a "key" node, LIMIT it, then add something to the query to get just keys that are greater than the last one, you move the paging logic out of the db and you get way better results.This is a common tactic in the relational db world, see http://docs.spring.io/spring-batch/trunk/reference/html/readersAndWriters.html#pagingItemReaders
Paul, Yes!But as you know, RDF engines/stores are also relational database technology related. The problem is that folks assume said realm is SQL-specific RDBMS implementations are on the only kind of RDBMS implementations, and as a result we have an artificial learning curve, as exemplified here.
RDF provides more powerful use of keys than SQL, due to the fact that it exposes relation semantics which are otherwise conflated, and obscured in a SQL-specific RDBMS scenario .
-- Regards, Kingsley Idehen Founder & CEO OpenLink Software Company Web: http://www.openlinksw.com Personal Weblog 1: http://kidehen.blogspot.com Personal Weblog 2: http://www.openlinksw.com/blog/~kidehen Twitter Profile: https://twitter.com/kidehen Google+ Profile: https://plus.google.com/+KingsleyIdehen/about LinkedIn Profile: http://www.linkedin.com/in/kidehen Personal WebID: http://kingsley.idehen.net/dataspace/person/kidehen#this
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
