You can group them into the same EXPLICIT transaction to avoid the repeated setting of the checkpoint limit, and in fact, if you are building queries based on the results of queries, you WANT them all in a single transaction so the data can't change on you while you are building the selects. This can help things some.