Hi Egon,
No problem, looking back through the thread I presume the query you are running
is:
SELECT DISTINCT ?property
WHERE { [] ?property [] }
ORDER BY ?property
I believe ?
Can you provide the output of running the profile('<query>') function which
will provide the query execution plan and compiler and execution times:
profile('SPARQL SELECT DISTINCT ?property WHERE { [] ?property [] }
ORDER BY ?property')
and also the query without the "ORDER BY" for comparison:
profile('SPARQL SELECT DISTINCT ?property WHERE { [] ?property [] } ')
Looking at the status('') output only "137785 " of the "680000" buffers are in
use so there in plenty of memory available so the "129857455" triples should
be hosted in memory.
I am wondering if this maybe due to a bad query plan. Note there have been some
major query optimizer fixes that have been pushed to the git Virtuoso open
source develop/7 branch at:
http://github.com/openlink/virtuoso-opensource
thus I would recommend performing an updated build from the branch to see if
the problem persists ...
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 8 Dec 2013, at 16:54, Egon Willighagen <egon.willigha...@gmail.com> wrote:
> Hi Hugh,
>
> my apologies for the late reply... been busy again...
>
> On Wed, Oct 16, 2013 at 4:19 AM, Hugh Williams <hwilli...@openlinksw.com>
> wrote:
>> What is the current triple count of your Virtuoso Server instance.
>
> 129857455
>
>> Also when the database is "warm" can you please provide the output of
>> running the "status();" command from isql to see the state of the database.
>
> ------------------------------------------------------------------------------------------------
> SQL> status();
> REPORT
> VARCHAR
> _______________________________________________________________________________
>
> OpenLink Virtuoso Server
> Version 07.00.3203-pthreads for Linux as of Aug 12 2013
> Started on: 2013-12-05 07:42 GMT+1
>
> Database Status:
> File size 5972688896, 729088 pages, 266152 free.
> 680000 buffers, 137785 used, 1 dirty 0 wired down, repl age 0 0 w.
> io 0 w/crsr.
> Disk Usage: 138686 reads avg 0 msec, 0% r 0% w last 112 s, 6321 writes,
> 532 read ahead, batch = 256. Autocompact 0 in 0 out, 0% saved.
> Gate: 2916 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap.
> Log = virtuoso.trx, 467 bytes
> 462883 pages have been changed since last backup (in checkpoint state)
> Current backup timestamp: 0x0000-0x00-0x00
> Last backup date: unknown
> Clients: 1 connects, max 1 concurrent
> RPC: 6 calls, 1 pending, 1 max until now, 0 queued, 0 burst reads
> (0%), 0 second 0M large, 126M max
> Checkpoint Remap 0 pages, 0 mapped back. 16 s atomic time.
> DB master 729088 total 266152 free 0 remap 0 mapped back
> temp 83200 total 83195 free
>
> Lock Status: 0 deadlocks of which 0 2r1w, 0 waits,
> Currently 1 threads running 0 threads waiting 0 threads in vdb.
> Pending:
>
> Client 1113:1: Account: dba, 337 bytes in, 2464 bytes out, 1 stmts.
> PID: 22729, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 1 threads.
> Locks:
>
>
> Running Statements:
> Time (msec) Text
> 70 status()
>
>
> Hash indexes
>
>
> 37 Rows. -- 71 msec.
> ------------------------------------------------------------------------------------------------
>
> I have no idea how to start with this feedback or how to link this to
> settings. Is there documentation that explains that?
>
> Egon
>
> --
> Dr E.L. Willighagen
> Postdoctoral Researcher
> Department of Bioinformatics - BiGCaT
> Maastricht University (http://www.bigcat.unimaas.nl/)
> Homepage: http://egonw.github.com/
> LinkedIn: http://se.linkedin.com/in/egonw
> Blog: http://chem-bla-ics.blogspot.com/
> PubList: http://www.citeulike.org/user/egonw/tag/papers
> ORCID: 0000-0001-7542-0286
>
> ------------------------------------------------------------------------------
> Sponsored by Intel(R) XDK
> Develop, test and display web and hybrid apps with a single code base.
> Download it for free now!
> http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Sponsored by Intel(R) XDK
Develop, test and display web and hybrid apps with a single code base.
Download it for free now!
http://pubads.g.doubleclick.net/gampad/clk?id=111408631&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
