On 11/07/12 19:59, Michael Brunnbauer wrote:
Hello Andy,
On Wed, Jul 11, 2012 at 07:04:21PM +0100, Andy Seaborne wrote:
I have just replaced Joseki 3.4.3 with Fuseki 0.2.3 for our projects
www.foaf-search.net and www.semantic-search.info.
Which version of TDB are you using with Joseki?
I was using the Joseki-3.4.3 distribution which contains tdb-0.8.8.jar.
That's a big jump so there are various things to check out.
Could you try:
1/ SELECT (count(*) AS ?count) WHERE ...
and let me know the counts.
2/ SELECT (count(DISTINCT *) AS ?count) WHERE ...
and let me know the counts.
3/ Change SELECT DISTINCT ?o to SELECT ?o
(more inline)
It should make little or no difference (for the same version of TDB, and
little across TDB's for query).
Query? Update?
Query
What operations are you performing?
All of this should be done in 1-2 seconds instead of 8:
..
Lots of POST, not GET
What is sending the queries?
(in case the network costs are the issue)
but it could be the transaction overhead (although that would make it
rather high - this are read-only operations).
On how much data?
The foaf TDB has 357GB. But I also have performance problems with the dbpedia
TDB (45GB). Both use quads.
And how many quads? I don't speak bytes!
On what OS?
Linux 3.2.21 with JDK 6u33-x64.
Spaces break the syntax, which is why you have "<...." and no ">"
What's the stats.opt got in it?
45991 lines. Here are the broken ones:
(<http://www.w3.org/2003/12/exif/ns/Digital Zoom Ratio> 1)
(<http://www.w3.org/2003/12/exif/ns/Scene Capture Type> 1)
Can I fix the stats.opt
file by removing lines with bad URIs ?
Yes -
Done. Does not help (I have restarted fuseki).
The warnings should go away.
also try "fixed.opt"
huh ?
instead of a (broken) stats.opt , put in a file called "fixed.opt".
But the performance is not to do with stats - this is all single quad
lookup.
You should fix the URIs as well.
(They aren't in the vocabulary either)
I don't understand.
There is no such <http://www.w3.org/2003/12/exif/ns/Digital Zoom Ratio>
in the W3C vocabulary that I can find.
Andy
Regards,
Michael Brunnbauer
