Hi Bart,
Hmmm, note sure why you would need to run as root to get the profile plan,
especially if it was not required for explain ?
Anyway, the query profiles will be analysed by development would will be able
to advise on how the speed might be improved or why they are slow, so will let
you know what they report ...
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 24 Apr 2014, at 16:25, Bart Vandewoestyne <bart.vandewoest...@telenet.be>
wrote:
> On 2014-04-24 16:45, Bart Vandewoestyne wrote:
>>
>> I'm still struggling to get this profiling going... After starting up
>> my Virtuoso, i immediately try profiling from within ISQL but I get no
>> output:
>>
>> bart@hp-g7-02:~$ isql
>> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
>> Type HELP; for help and EXIT; to exit.
>> SQL> sparql SELECT (COUNT(*) AS ?no) { ?s ?p ?o };
>> Connected to OpenLink Virtuoso
>> Driver: 07.10.3208 OpenLink Virtuoso ODBC Driver
>> no
>> INTEGER
>> _______________________________________________________________________________
>>
>>
>> 2164637247
>>
>> 1 Rows. -- 1592 msec.
>> SQL> profile('sparql SELECT (COUNT(*) AS ?no) { ?s ?p ?o }');
>>
>> Done. -- 1610 msec.
>> SQL>
>>
>> Am I doing something wrong? Or overlooking something?
>>
>> Kind regards,
>> Bart
>
> Nevermind, the problem seemed to be that I started my virtuoso as a
> normal user instead of as root.
>
> Profiling info for both query 1 and 4 is now also available under
>
> https://www.dropbox.com/sh/hm0nj8q0j6pnx1k/cEcfYD6h-P
>
> For me, it's very hard to interpret the profiling information... I
> cannot deduce from it why query 1 and 4 take so much time and what I
> could do to speed them up. Can anybody shed some light here?
>
> Any suggestions highly appreciated.
>
> Kind regards,
> Bart
>
> ------------------------------------------------------------------------------
> Start Your Social Network Today - Download eXo Platform
> Build your Enterprise Intranet with eXo Platform Software
> Java Based Open Source Intranet - Social, Extensible, Cloud Ready
> Get Started Now And Turn Your Intranet Into A Collaboration Platform
> http://p.sf.net/sfu/ExoPlatform
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
