Hi Hugh,
I tried to run the profile procedure via isql-vt, but I got an error saying
that it's undefined:
*** Error 42001: [Virtuoso Driver][Virtuoso Server]SR185: Undefined
procedure DB.DBA.profile
How to load the procedure definition?
Note: I'm running Virtuoso Open Source Edition (Row Store) (multi
threaded), Version 6.1.7-rc1.3127-pthreads as of May 21 2013
Best,
Jindřich
--
Jindřich Mynarz
http://mynarz.net/#jindrich
On Fri, Oct 11, 2013 at 1:01 PM, Hugh Williams <hwilli...@openlinksw.com>wrote:
> Hi Nicola,
>
> Can you please provide the output of running the profile() function for
> these two queries ie replace explain with profile, which provides more
> information on the query execution:
>
> http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#readingqueryprofile
>
> There has not really been changes indexes but more in the query optimiser
> were the plans may have changed which the explain and profile outputs
> should help identify for your query ...
>
> 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 11 Oct 2013, at 09:52, Nicola Vitucci <nicola.vitu...@gmail.com> wrote:
>
> Hi all,
>
> I got a problem with Virtuoso 7.0.0 and I think it's related to the use
> of indices. My question is: have there been any big changes between the
> rc2 and the stable version, so that indices are not completely
> compatible across the two versions?
>
> Here is one of the queries I ran on both versions (just the names have
> been changed):
>
> PREFIX int: <namespace#> CONSTRUCT {?s int:new_prop ?n} WHERE {?s <prop>
> ?c . ?c rdfs:label ?n}
>
> and below you can find the result of EXPLAINing the query on the rc2
> version first and then on 7.0.0. The query is reasonably fast on rc2
> (41659 msec with ResultSetMaxRows = 10000), while it takes an awfully
> long time (1011741 msec, same ResultSetMaxRows) on 7.0.0. Other queries
> have a similar problem.
>
> Any ideas?
>
> Thank you,
>
> Nicola
>
> ------------------------
> Virtuoso rc2
>
> {
>
> Precode:
> 0: {
> s# 63 cluster outer seq start, set no <V $44 set_ctr in>
> save ctx:()
>
> Precode:
> 0: <V $27 vector x> := Call vector ( 1 , 0 , 3 , #new_prop , 1
> , 1 )
> 5: <V $29 vector x> := Call vector (<V $27 vector x>)
> 10: <V $31 vector x> := Call vector ()
> 15: BReturn 0
> s# 89 Fork 46
> {
> s# 70 from DB.DBA.RDF_QUAD by RDF_QUAD 2.5e+05 rows
> Key RDF_QUAD ASC (<V $35 s_1_7_t1.O an>, <V $34 s_1_7_t1.S rn>)
> inlined P = #prop
> row specs: O LIKE <c T�>
>
> s# 77 from DB.DBA.RDF_QUAD by RDF_QUAD 1 rows
> Key RDF_QUAD ASC (<V $38 s_1_7_t2.O an>)
> inlined P = #label , S = <v $81 k_s_1_7_t1.O S83 rn>
> vector param casts: <V $35 s_1_7_t1.O an>-> <v $81 k_s_1_7_t1.O S83 rn>
>
>
> After code:
> 0: <V $40 __ro2lo x> := Call __ro2lo (<V $38 s_1_7_t2.O an>)
> 5: <V $42 vector x> := Call vector (<r $34 s_1_7_t1.S via S77
> S83>, <V $40 __ro2lo x>)
> 10: if ($47 "user_aggr_notfirst" = 1 ) then 25 else 14 unkn 14
> 14: $47 "user_aggr_notfirst" := := artm 1
> 18: <V $49 user_aggr_ret x> := Call DB.DBA.SPARQL_CONSTRUCT_INIT
> ($48 "user_aggr_env")
> 25: <V $49 user_aggr_ret x> := Call DB.DBA.SPARQL_CONSTRUCT_ACC
> ($48 "user_aggr_env", <r $29 vector via S77 S83 S70>, <V $42 vector x>,
> <r $31 vector via S77 S83 S70>, 1 )
> 32: BReturn 0
> }
> s# 92 skip node 1 <none> <V $44 set_ctr in>
>
> After code:
> 0: <V $50 callret-0 x> := Call DB.DBA.SPARQL_CONSTRUCT_FIN ($48
> "user_aggr_env")
> 7: BReturn 0
> s# 96 Subquery Select(<V $50 callret-0 x>)
> set no: <r $44 set_ctr via S92>
> }
>
> 8: <none> := Call DB.DBA.RDF_DICT_OF_TRIPLES_TO_THREE_COLS ($100
> "scalar")
> 15: BReturn 0
> END Node
> }
>
> ------------------------
> Virtuoso 7.0.0
>
> {
>
> Precode:
> 0: {
>
> Precode:
> 0: vector := Call vector ( 1 , 0 , 3 , #new_prop , 1 , 1 )
> 5: vector := Call vector (vector)
> 10: vector := Call vector ()
> 15: BReturn 0
> { fork
> RDF_QUAD 4.2e+08 rows(s_1_7_t2.S, s_1_7_t2.O)
> inlined P = #label
>
> Precode:
> 0: __ro2lo := Call __ro2lo (s_1_7_t2.O)
> 5: BReturn 0
> RDF_QUAD_POGS 33 rows(s_1_7_t1.S)
> P = #prop , O = cast
>
> After code:
> 0: vector := Call vector (s_1_7_t1.S, __ro2lo)
> 5: if ($47 "user_aggr_notfirst" = 1 ) then 20 else 9 unkn 9
> 9: $47 "user_aggr_notfirst" := := artm 1
> 13: user_aggr_ret := Call DB.DBA.SPARQL_CONSTRUCT_INIT ($48
> "user_aggr_env")
> 20: user_aggr_ret := Call DB.DBA.SPARQL_CONSTRUCT_ACC ($48
> "user_aggr_env", vector, vector, vector, 1 )
> 27: BReturn 0
> }
> skip node 1 <none> set_ctr
>
> After code:
> 0: callret-0 := Call DB.DBA.SPARQL_CONSTRUCT_FIN ($48 "user_aggr_env")
> 7: BReturn 0
> Subquery Select(callret-0)
> }
>
> 8: <none> := Call DB.DBA.RDF_DICT_OF_TRIPLES_TO_THREE_COLS ($100
> "scalar")
> 15: BReturn 0
> END Node
> }
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
