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. > 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: 20:51:42 INFO Fuseki :: [649] POST http://ts.foaf-search.net:3030/foaf/query 20:51:42 INFO Fuseki :: [649] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://dbpedia.org/class/yago/Person100007846> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:42 INFO Fuseki :: [649] OK/select 20:51:42 INFO Fuseki :: [649] 200 OK 20:51:42 INFO Fuseki :: [650] POST http://ts.foaf-search.net:3030/foaf/query 20:51:42 INFO Fuseki :: [650] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://dbpedia.org/class/yago/LivingPeople> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:43 INFO Fuseki :: [650] OK/select 20:51:43 INFO Fuseki :: [650] 200 OK 20:51:43 INFO Fuseki :: [651] POST http://ts.foaf-search.net:3030/foaf/query 20:51:43 INFO Fuseki :: [651] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://www.opengis.net/gml/_Feature> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:43 INFO Fuseki :: [651] OK/select 20:51:43 INFO Fuseki :: [651] 200 OK 20:51:43 INFO Fuseki :: [652] POST http://ts.foaf-search.net:3030/foaf/query 20:51:43 INFO Fuseki :: [652] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://dbpedia.org/class/yago/YagoGeoEntity> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:44 INFO Fuseki :: [652] OK/select 20:51:44 INFO Fuseki :: [652] 200 OK 20:51:44 INFO Fuseki :: [653] POST http://ts.foaf-search.net:3030/foaf/query 20:51:44 INFO Fuseki :: [653] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://dbpedia.org/class/yago/GeoclassPopulatedPlace> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:44 INFO Fuseki :: [653] OK/select 20:51:44 INFO Fuseki :: [653] 200 OK 20:51:44 INFO Fuseki :: [654] POST http://ts.foaf-search.net:3030/foaf/query 20:51:44 INFO Fuseki :: [654] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://purl.org/rss/1.0/channel> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:45 INFO Fuseki :: [654] OK/select 20:51:45 INFO Fuseki :: [654] 200 OK 20:51:45 INFO Fuseki :: [655] POST http://ts.foaf-search.net:3030/foaf/query 20:51:45 INFO Fuseki :: [655] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://dbpedia.org/class/yago/Actor109765278> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:45 INFO Fuseki :: [655] OK/select 20:51:45 INFO Fuseki :: [655] 200 OK 20:51:45 INFO Fuseki :: [656] POST http://ts.foaf-search.net:3030/foaf/query 20:51:45 INFO Fuseki :: [656] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://purl.org/ontology/mo/MusicArtist> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:46 INFO Fuseki :: [656] OK/select 20:51:46 INFO Fuseki :: [656] 200 OK 20:51:46 INFO Fuseki :: [657] POST http://ts.foaf-search.net:3030/foaf/query 20:51:46 INFO Fuseki :: [657] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://purl.org/ontology/bibo/Collection> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:47 INFO Fuseki :: [657] OK/select 20:51:47 INFO Fuseki :: [657] 200 OK 20:51:47 INFO Fuseki :: [658] POST http://ts.foaf-search.net:3030/foaf/query 20:51:47 INFO Fuseki :: [658] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://data.ordnancesurvey.co.uk/ontology/admingeo/CivilParish> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:47 INFO Fuseki :: [658] OK/select 20:51:47 INFO Fuseki :: [658] 200 OK 20:51:47 INFO Fuseki :: [659] POST http://ts.foaf-search.net:3030/foaf/query 20:51:47 INFO Fuseki :: [659] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://dbpedia.org/class/yago/AmericanFilmActors> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:48 INFO Fuseki :: [659] OK/select 20:51:48 INFO Fuseki :: [659] 200 OK 20:51:48 INFO Fuseki :: [660] POST http://ts.foaf-search.net:3030/foaf/query 20:51:48 INFO Fuseki :: [660] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://dbpedia.org/class/yago/TheFootballLeaguePlayers> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:48 INFO Fuseki :: [660] OK/select 20:51:48 INFO Fuseki :: [660] 200 OK 20:51:48 INFO Fuseki :: [661] POST http://ts.foaf-search.net:3030/foaf/query 20:51:48 INFO Fuseki :: [661] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://dbpedia.org/class/yago/EnglishFootballers> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:48 INFO Fuseki :: [661] OK/select 20:51:48 INFO Fuseki :: [661] 200 OK 20:51:48 INFO Fuseki :: [662] POST http://ts.foaf-search.net:3030/foaf/query 20:51:48 INFO Fuseki :: [662] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://dbpedia.org/class/yago/AmericanTelevisionActors> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:49 INFO Fuseki :: [662] OK/select 20:51:49 INFO Fuseki :: [662] 200 OK 20:51:49 INFO Fuseki :: [663] POST http://ts.foaf-search.net:3030/foaf/query 20:51:49 INFO Fuseki :: [663] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://dbpedia.org/class/yago/AssociationFootballForwards> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:49 INFO Fuseki :: [663] OK/select 20:51:49 INFO Fuseki :: [663] 200 OK 20:51:49 INFO Fuseki :: [664] POST http://ts.foaf-search.net:3030/foaf/query 20:51:49 INFO Fuseki :: [664] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://dbpedia.org/class/yago/AssociationFootballDefenders> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:50 INFO Fuseki :: [664] OK/select 20:51:50 INFO Fuseki :: [664] 200 OK 20:51:50 INFO Fuseki :: [665] POST http://ts.foaf-search.net:3030/foaf/query 20:51:50 INFO Fuseki :: [665] Query = SELECT DISTINCT ?o WHERE { GRAPH ?g { <http://purl.org/dc/terms/DCMIType/Text> <http://www.w3.org/2000/01/rdf-schema#label> ?o }} 20:51:50 INFO Fuseki :: [665] OK/select 20:51:50 INFO Fuseki :: [665] 200 OK > On how much data? The foaf TDB has 357GB. But I also have performance problems with the dbpedia TDB (45GB). Both use quads. > 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). > also try "fixed.opt" huh ? > You should fix the URIs as well. > (They aren't in the vocabulary either) I don't understand. Regards, Michael Brunnbauer -- ++ Michael Brunnbauer ++ netEstate GmbH ++ Geisenhausener Straße 11a ++ 81379 München ++ Tel +49 89 32 19 77 80 ++ Fax +49 89 32 19 77 89 ++ E-Mail bru...@netestate.de ++ http://www.netestate.de/ ++ ++ Sitz: München, HRB Nr.142452 (Handelsregister B München) ++ USt-IdNr. DE221033342 ++ Geschäftsführer: Michael Brunnbauer, Franz Brunnbauer ++ Prokurist: Dipl. Kfm. (Univ.) Markus Hendel
