I would imagine that it partly depends upon your design and what it is you are querying against but setting up some tests and then running something like against your primary site server will give you the data that you can use to work it out
From: [email protected] [mailto:[email protected]] On Behalf Of Atkinson, Matt T Sent: 24 March 2015 16:06 To: [email protected] Subject: [mssms] Which of these options would cause the least impact on our site server? Need to create 2 pretty large collections for targeting of client settings (controlling BITS throttling). Is it more efficient to create a lot (approximately 2000) of small collections and include them in another collection, or is it better to create one collection with a large number of different queries to determine membership? Trying to have the least amount of performance impact on the site server. Matt Atkinson Client Systems Engineer 3601 Murray Blvd Ste. 175 Beaverton, OR 97005 W: 971-282-0342 C: 503-851-4620 _____ This message is intended for the sole use of the addressee, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
