Hi Hugh
Thanks for your reply ... my comments inline ...
On 07/05/2014 3:57, Hugh Williams wrote:
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
Ok, I'll do it!
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 ?
Yes, it is the same operation. Basically, this is the workflow
1. start the linux server
2. start virtuoso instance
3. perform the query ... it takes 23035 ms
4. restart virtuoso instance
5. perform the query ... it takes 643 ms
However, I'm going to update it following your suggestion and I'll let
you know
Best and thanks again
Boris
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
