Balance queries over time

[strupp]

Hi everybody,

is there a way to balance the queries over time? For example, a query with 600 Items runs every 5 Minutes. So the most balanced way would be 2 items per second. At the moment I'm able to balance 120 items per minute, but this query is executed in the first 5 seconds of every minute.
Thanks for your help,
strupp

[strupp]

No ideas?

[cigamit]

No, there is no mechanism for balancing over time, especially since its possible that each query can take longer than your .5 seconds depending on the query, slowness of the network, slowness of the responding server. I would see no need in particular for this at all, as it would be more problematic than helpful.

If you really want to slow down the query rate, add less process / threads and it will thus query less at once and thus take longer to do them all.