"I considered multiple queries:...but seemed like a drain on the server."

That's not the only problem. As all the query strings and query results are most likely sent through network, this approach actually uses a bit more bandwidth than needed.