On Mon, Oct 26, 2009 at 18:42, Hugh Williams wrote:
> Indicating their are 5 deadlocks in the database. Can you try running the
> following command form the isql command line too to try and forcibly kill
> and release all transactions and locks:
>
> txn_killall();
>
> As detailed at:
>
> http://do
Hello list,
the following query is rather slow on my Virtuoso 5.0.12 with 603.323 triples:
select ?date where { ?r a nfo:FileDataObject . ?r nie:lastModified ?date . }
ORDER BY ?date LIMIT 1
How can I optimize such queries? Do I need to define a specific index?
Thanks,
Sebastian Trueg
Hi Ivan,
On Thu, 22 Oct 2009 21:19:01 +0700 Ivan Mikhailov wrote:
In addition, I should warn you that SSD's lifetime under any database
application can be smaller than expected, depending on OS and drivers.
That's due to the nature of file I/O in databases. Some smart drivers
try to balance num
Hi James,
Looking at your status output I see:
Clients: 143 connects, max 5 concurrent
RPC: 2032 calls, -246 pending, 1 max until now, 0 queued, 0 burst
reads (0%), 9 second brk=548294656
Checkpoint Remap 278243 pages, 0 mapped back. 2176 s atomic time.
DB master 12523008 total 4875616 f
Using virtuoso 6-TP1, several weeks ago, I imported approx 500,000,000
triples from several bio2rdf graphs and built the additional bitmap indices
RDF_QUAD_GPOS, RDF_QUAD_OGPS, RDF_QUAD_OPGS, RDF_QUAD_POGS
I also created a free text index using:
DB.DBA.RDF_OBJ_FT_RULE_ADD(NULL, NULL, 'bio-ft-inde
