Are there tips to queue this or pause each query so that YQL can return the results before moving on to the next query. I am programming this in PHP and each query takes about 4 seconds. I am just using a "while loop" to go through my array of 800 queries.
How are you sending the YQL request in PHP? In a lot of other languages that I have used these CURL-like requests will be synchronous anyways, so why is there the need to pause actively?
Also in terms of speeding things up, did you look at YQL's query.multi to parallelize queries? Example for YQL console. Try it
select * from query.multi where queries="show tables;select * from feed where url='http://www.javarants.com/rss'"