Hi Bart,
Is seems the "set profile on" option is not implemented in the VOS isql
program, so will have to make a request to have that option added as it is in
the commercial version. But you still can just run the profile command with the
query in single quotes directly from isql ie
SQL> profile('select count(*) from sys_users');
result
LONG VARCHAR
_______________________________________________________________________________
15
{
time 14% fanout 1 input 1 rows
time 8.4% fanout 1 input 1 rows
{ fork
time 74% fanout 0 input 1 rows
SYS_USERS_ID 15 rows()
After code:
0: sum count 1 set no set_ctr
5: BReturn 0
}
time 3% fanout 0 input 1 rows
Select (count)
}
0 msec 10% cpu, 1 rnd 14 seq 0% same seg 0%
same pg
Compilation: 0 msec 0 reads 0% read 0 messages 0% clw
4 Rows. -- 1 msec.
SQL>
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 09:28, Bart Vandewoestyne <bart.vandewoest...@telenet.be>
wrote:
> On 2014-04-23 14:55, Hugh Williams wrote:
>> Hi Bart,
>>
>> You still have not provided the "profile" for each query. You can do
>> this by running "SET PROFILE ON/OFF" as did for the explain plans ...
>
> Hugh,
>
> I'm confused here. I am following the instructions on
>
> http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtTipsAndTricksAanalyzingSPARQLQuery
>
> But SET PROFILE ON; does not seem to work???
>
> bart@hp-g7-02:~$ isql
> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
> Type HELP; for help and EXIT; to exit.
> SQL> SET PROFILE ON;
> Connected to OpenLink Virtuoso
> Driver: 07.10.3208 OpenLink Virtuoso ODBC Driver
>
> *** Error 42S22: [Virtuoso Driver][Virtuoso Server]SR077: Bad option for SET
> at line 1 of Top-Level:
> SET PROFILE ON
> SQL>
>
> The SPARQL_TRANSLATE and EXPLAIN seem to work:
>
> SQL> SET SPARQL_TRANSLATE ON;
> SQL> SET SPARQL_TRANSLATE OFF;
> SQL> SET EXPLAIN ON;
> SQL> SET EXPLAIN OFF;
> SQL>
>
> Am I overlooking something? My virtuoso version is:
>
> Virtuoso Open Source Edition (Column Store) (multi threaded)
> Version 7.1.1-dev.3208-pthreads as of Apr 17 2014
> Compiled for Linux (x86_64-unknown-linux-gnu)
> Copyright (C) 1998-2014 OpenLink Software
>
>
> 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
