On 2014-04-18 12:53, Hugh Williams wrote: > Hi Bart, > > If you cannot provide the data then the next best thing would be to get > the "profile" for the problem queries ie the compiler and execution > plans for analysis as detailed at: > > http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery > http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#EfficientSQL
I couldn't resist. :-) The query explains for my two slowest queries are at https://dl.dropboxusercontent.com/u/32340538/query_explain1.txt https://dl.dropboxusercontent.com/u/32340538/query_explain2.txt As I have no previous experience with query plans, for me, this is Chinese... i cannot make up anything of it. Does it shed a light on what I can do to speed things up? Any parameters I can try tweaking? Kind regards, Bart ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
