Hello Andy, On Wed, Jul 11, 2012 at 08:18:53PM +0100, Andy Seaborne wrote: > Could you try: > > 1/ SELECT (count(*) AS ?count) WHERE ... > and let me know the counts.
6 2 0 0 0 ... > 2/ SELECT (count(DISTINCT *) AS ?count) WHERE ... > and let me know the counts. 6 2 0 0 0 ... > 3/ Change SELECT DISTINCT ?o to SELECT ?o Not faster. > Lots of POST, not GET > What is sending the queries? > (in case the network costs are the issue) http://sparql-wrapper.sourceforge.net/ Version 1.4.1 from localhost I did not change anything except replace Joseki with Fuseki. > but it could be the transaction overhead +1 > >> 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! The dbpedia TDB (which also makes problems) has 156966301 quads (I just counted them) and the foaf TDB should have more than 600 mio. > >>>Can I fix the stats.opt > >>>file by removing lines with bad URIs ? > >Done. Does not help (I have restarted fuseki). > The warnings should go away. Yes - they are gone. > >>You should fix the URIs as well. > >>(They aren't in the vocabulary either) > There is no such <http://www.w3.org/2003/12/exif/ns/Digital Zoom Ratio> > in the W3C vocabulary that I can find. As usual, the bad stuff was crawled. 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 [email protected] ++ 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
