timeouts are still high this morning about 40% of the YQL queries in my app...
they're also random. When I retry the same query 2 seconds after it fails, it often works...
what could it be ?
The YQL Engines do adhere to the rate limits described on the main page. Bursty traffic can result in 999 errors. Since the overall public ratelimit is 1000/hr, per minute you should be easily be able to make 16 requests. If its anything greater than 16, then the ratelimiter can get kicked in. I'd recommend spreading out the load across time.
example: The spikes/bursts in traffic have been removed such that given 1000 requests/hour, you cannot make 999 requests in the 1st 1/2 hour and then wait for another 1/2 hour for the next burst in traffic.
here are the only 3 type of queries that I execute select * from fantasysports.teams.roster where league_key='242.l.637629' select * from fantasysports.teams where use_login=1 and game_key=248 select * from fantasysports.leagues where use_login=1 and game_key=248
I'm not sure how to find the IP address as my app runs from the cloud....
i have a similiar problem. my YQL php script takes really long to complete. on my home testing server it takes ages and on my live webspace the script times out and my website is not displayed any more because the whole wordpress process hangs.
here is my script that i use to fetch my videos and pic from vimeo and flickr:
/* Vimeo */ $YQLquery = 'select video.id, video.url, video.title, video.description, video.width, video.height, video.thumbnail_small, video.thumbnail_large, video.thumbnail_medium, video.tags from vimeo.user.videos where username="user1282871";';
/* Flickr search by user id */ $YQLquery .= 'select id, farm, server, secret, title, description, tags, dateuploaded from flickr.photos.info(1000) where photo_id in(select id from flickr.photos.search(1000) where user_id="49412513@N02") | sort(field="dateuploaded",descending="false")';
/* The YQL web service root with JSON as the output */ $YQLroot = 'http://query.yahooapis.com/v1/public/yql?format=json&env=http%3A%2F%2Fdatatables.org%2Falltables.env';
/* Assemble the query */ $YQLquery = "select * from yql.query.multi where queries='".$YQLquery."'"; $YQLurl = $YQLroot . '&q=' . urlencode($YQLquery);
/* Do the curl call (access the data just like a browser would) */ $YQLch = curl_init(); curl_setopt($YQLch, CURLOPT_URL, $YQLurl); curl_setopt($YQLch, CURLOPT_RETURNTRANSFER, 1); $YQLoutput = curl_exec($YQLch); curl_close($YQLch); $YQLdata = json_decode($YQLoutput); $YQLresults = $YQLdata->query->results->results;
I noticed this problem yesterday evening and it still doesn't work today. My "app" is just a few Yahoo Pipes feeds that is parsed on a website I'm developing. It is not yet publicly accessible so the request limits won't kick in here. Here's the error I get:
This Pipe ran successfully but encountered some problems: