Hi Jindřich,
Profile() is new in v7 and not supported in v6 ...
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/
Twit
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)
Hi Hugh,
thanks for the reply. Unfortunately I could't PROFILE any of the queries
because both ended up with an "Error 22012: [Virtuoso Driver][Virtuoso
Server]SR083: Division by zero". Any alternatives to do some profiling?
Thanks,
Nicola
Il 11/10/2013 13:01, Hugh Williams ha scritto:
> Hi Nic
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 real
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 versi
