On 2014-04-24 17:59, Hugh Williams wrote:
> 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 ?
Could it have to do with file/directory permissions? The directory from
which I start virtuoso has the following p
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 k
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;
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 quer
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> prof
On 4/24/14 3:58 AM, Bart Vandewoestyne wrote:
Hello list,
I noticed that for most (if not all) of my queries, the first time the
query is run (right after i started the virtuoso server), it takes much
longer than all subsequent runs. See e.g. my query timings at
https://dl.dropboxusercontent.c
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/datas
Hello list,
I noticed that for most (if not all) of my queries, the first time the
query is run (right after i started the virtuoso server), it takes much
longer than all subsequent runs. See e.g. my query timings at
https://dl.dropboxusercontent.com/u/32340538/long_first_query.png
Using dsta
