What Andy was trying to point out is that many public endpoints have usage limits e.g. maximum results, maximum query runtime, maximum requests/minute etc which are put in place to prevent them being abused e.g. by poorly written clients
With a query like yours which queries a large portion of the data and then filters over it there is a high likelihood that you run into one of those limits (typically the maximum query runtime) which depending on the configuration of the remote system may either result in an error or partial, incomplete results. What limits are in place and what happens when you hit those limits are questions you would need to address to the person(s)/organization(s) running the SPARQL endpoints you are using. Rob On 10/03/2014 00:45, "José Luis Larroque" <[email protected]> wrote: >@Martynas: > >Thanks anyway, i will use your advice and do that, instead of those ugly >OR >that i'm actually doing :D > >I really don't know if i'm doing "a faceted search", it's a concept that >already see in some place but i didn't fully understand it. Maybe i'm, who >know's ! :D > >@Andy: > >Sorry andy for the format of the querys, i didn't want to alter the query >generated by my code in any way for been more exact at the moment of >asking >question's here. > >You are right, apparently some movies don't have a date and that was >stopping the query for finding more results. > >I'm putting an "OPTIONAL{ }" clause around dc:date, for solving this >issue. >I believe that i'm solving my problem doing this, so i don't understand >your last two lines in your answer. > >Thanks to both!! > > >2014-03-09 6:44 GMT-03:00 Andy Seaborne <[email protected]>: > >> On 09/03/14 02:07, José Luis Larroque wrote: >> >>> This query doesn't work: >>> >> >> Please make queries readable in email. >> >> >> PREFIX dc: <http://purl.org/dc/terms/>PREFIX movie: < >>> http://data.linkedmdb.org/resource/movie/>SELECT ?titulo ?id ?fecha >>> WHERE{ >>> ?movie movie:actor ?actor .?movie dc:title ?titulo . ?movie dc:date >>> ?fecha.?movie movie:filmid ?id .FILTER( ?actor = < >>> http://data.linkedmdb.org/resource/actor/30711> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31259> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/29536> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/30485> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31204> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/29852>)} >>> >> >> Some movies don't have dc:date. Maybe the pattern fails in other ways >>as >> well. >> >> >>> But this one, does: >>> >> >> I get results for just one actor, actor/29512, who is in many films >>(~30) >> and no others. That's out of about 118. >> >> If I remove actor/29512 I get no matches. >> >> data.linkedmdb.org has internal usage limits after which it stops the >> query execution. Combined with a graph pattern that excludes >>possibilities >> on matching, maybe the limits are being triggered. >> >> You'll need to ask them about that. >> >> Andy >> >> >> PREFIX dc: <http://purl.org/dc/terms/>PREFIX movie: < >>> http://data.linkedmdb.org/resource/movie/>SELECT ?titulo ?id ?fecha >>> WHERE{ >>> ?movie movie:actor ?actor .?movie dc:title ?titulo . ?movie dc:date >>> ?fecha.?movie movie:filmid ?id .FILTER( ?actor = < >>> http://data.linkedmdb.org/resource/actor/68186> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/9547> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/570> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/38579> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/9546> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31700> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/35706> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/42962> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/45825> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/35702> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/30922> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/37416> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/55943> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/36078> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/34357> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/30535> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/37983> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/29961> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/9332> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/30532> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/29959> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/30723> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/36453> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/30913> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31101> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/38167> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31099> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/33199> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/30715> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/40456> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/46372> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/38156> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/42356> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/32996> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/62792> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/37770> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/62790> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/34712> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/41397> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/331> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/37956> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/37765> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/44446> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31454> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/55137> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/46350> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/33169> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/44817> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31827> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/34309> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/37743> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/29718> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/35257> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/34492> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/301> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/37927> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/10994> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/30857> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31047> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31810> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31997> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/50332> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/29512> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31421> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/33712> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/859> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31790> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/29689> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/36564> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/34270> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/36752> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/50122> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/36553> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/37316> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/32730> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/29865> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/1215> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/29864> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/33492> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/39604> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31581> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/65000> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31193> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/64999> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/40168> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/45898> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/64998> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/29851> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/37681> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/37680> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/51> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/34430> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/30610> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31565> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/41305> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/10362> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/10361> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/43399> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/43398> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/39> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/41867> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/34989> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31932> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31549> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/34222> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/38614> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/32501> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/37650> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/32108> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/30769> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/31914> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/43558> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/38396> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/32093> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/30373> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/33046> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/60548> || ?actor = < >>> http://data.linkedmdb.org/resource/actor/32661>)} >>> >>> The only difference between both, are the size, because both are almost >>> identical, with the exception that the second has a OR more bigger. >>> >>> Both are code-generated querys, and the second query can't be tested >>> against the sparql dbpedia endpoint, because it's too big. Using jena >>> framework against the dbpedia enpoint, works like a charm, but not the >>> first one. Any idea why? >>> >>> Jose >>> >>> >>
