Hi Boris,
The first recommendation would be to update your open source build to the
latest develop/7 branch which is at 07.10.3208 containing many query optimizer
and other improvements ...
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSGitUsage
I wouldn't expect switching from a VM to physical machine to cause such
behaviour, are you sure the servers are configured the same ? I also don't
understand what you mean by when starting the server a query takes 23035ms and
then restarting it take 643ms as you appear to have performed the same
operation, or is this an intermittent occurrence ?
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 6 May 2014, at 09:53, Boris Villazon-Terrazas <bvilla...@isoco.com> wrote:
> Hi all
>
> I have a virtuoso instance (Version 7.0.0.3203-pthreads as of Sep 13
> 2013) over a VM, 32 Gb RAM, Intel(R) Xeon(R) CPU X5680 @ 3.33GHz.
> CentOS release 6.3
> From time to time I have to restart that server, and when I start
> virtuoso the performance is not good, for example for a particular query
> [1] I got 23035 ms.
> But If I restart virtuoso again, for the same query I got 643 ms ....
> There is no additional information on the logs
>
> AFAIR I didn't have this behavior on a physical server ...
>
> do you have any idea why this is happening?
>
> Apologies if the question is a bit trivial.
>
> Best
> Boris
>
> [1] SELECT DISTINCT ?author2 ?authorName
> WHERE {
> <...id1> ex:p1 ?authorship.
> ?authorship ex:p2 ?author.
> ?author ex:p3 ?authorship2 .
> ?authorship2 ex:p4 ?resource .
> ?resource ex:p1 ?authorship3 .
> ?authorship3 ex:p2 ?author2 .
> ?author2 rdfs:label ?authorName
> FILTER not
> EXISTS {
> ?author2 ex:p3 ?authorshipN.
> <...id1> ex:p1 ?authorshipN.
> }} order by ?authorName
>
>
> ------------------------------------------------------------------------------
> Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
> • 3 signs your SCM is hindering your productivity
> • Requirements for releasing software faster
> • Expert tips and advice for migrating your SCM now
> http://p.sf.net/sfu/perforce
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
• 3 signs your SCM is hindering your productivity
• Requirements for releasing software faster
• Expert tips and advice for migrating your SCM now
http://p.sf.net/sfu/perforce
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
