given a list of facilityIds can I do a DB query and get a list of corresponding facility entities

I have a list of facilityIds and I want the entities. I know I could put it in a for loop and do x number of database queries, but I was hoping there was a faster way since I know that DB queries are the bottleneck. Thanks Patrick

Re: given a list of facilityIds can I do a DB query and get a list of corresponding facility entities

Use the IN operator. -David On Apr 12, 2010, at 2:47 PM, Patrick wrote: I have a list of facilityIds and I want the entities. I know I could put it in a for loop and do x number of database queries, but I was hoping there was a faster way since I know that DB queries are the bottleneck.