Hi Bart,
The explain command whilst useful only provide the compile into,, where the new
v7 "profile(0" function provided both compile and execute info. and it was I
requested ie
profile('select * from table where field = ''text''');
The plans will be analysed by development ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 18 Apr 2014, at 16:13, Bart Vandewoestyne <bart.vandewoest...@telenet.be>
wrote:
> 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
------------------------------------------------------------------------------
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
