On 2014-04-24 15:16, Hugh Williams wrote:
> 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
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
------------------------------------------------------------------------------
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
