Good to hear!

On 27/07/2020 14:54, Wolfgang Fahl wrote:
Dear Jena Users,

at

http://wiki.bitplan.com/index.php/Get_your_own_copy_of_WikiData

i have documented several attempts to import WikiData into Jena. After Jonas Sourlier reported a success using a 4 TB SSD i tried
the same approach. It is documented at:

http://wiki.bitplan.com/index.php/WikiData_Import_2020-07-15

The attempt was limited to the truthy statements but still gives full access to the full content of WikiData. This is especially important for longer running queries.  One of the followup questions would be how queries can be sped up in this environment.

E.g. i tried:

SELECT  (COUNT(*)  as  ?Triples)  WHERE  {  ?s  ?p  ?o}

which took 5516 secs to answer that 5.250.681.892 triples are in the data set.

Counting a bit of tradoff - TDB does not manage the count separately, when it needs to, it does actually count the triple table. And, especially when cold, that's expensive.

The upside is that it is right and included any changes in the current transaction.

    Andy


Yours

   Wolfgang


--

Wolfgang Fahl
Pater-Delp-Str. 1, D-47877 Willich Schiefbahn
Tel. +49 2154 811-480, Fax +49 2154 811-481
Web:http://www.bitplan.de

Reply via email to