On 12/14/15 9:21 AM, Efimov, Alexander wrote: > > Hi, > > > > I’ve built R2RML mappings, but my SPARQL Query (I expect that to be > joining across about 10 views in DB) runs for hours. > > Is there a way to get a SQL query which Virtuoso generates and runs > over the database views? > > I have tried to use trace_on(); command but have nothing human > readable in terms of SQL queries executed. > > > > Thanks. >
Efimov, I don't quite understand what you are doing, but I would suggest you tried the following: 1) Make a SQL view from you 10 table query -- have a sense of the performance of this view 2) Use the Virtuoso RDF Views Wizard to generate RDF Views script (this includes R2RML generation) 3) Choose the option to make materialized RDF Views (i.e., to actually generate physical rather than virtual triples in the quad store that are syn'cd with source) 4) Re-test outcome and provide feedback about performance . Kingsley > > > ------------------------------------------------------------------------------ > > > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users -- 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
------------------------------------------------------------------------------
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
