Offhand I'm thinking the latter, as the addition of 2,000 collections on top of what already exists may well hammer Collection Evaluator pretty hard (depending on the frequency of evaluation cycle). OTOH, a single query with "...a large amount of different queries" could also hammer SQL quite hard on that collection's eval cycle... kind of a tough one to judge given what we know thus far, like how complex are the queries? How well are the queries optimized to minimize the SQL hit? Etc, etc...
Ed Aldrich | Channel Solutions Engineer | 1E +1 (401) 924-2293 [Description: Description: cid:[email protected]] Ent Cli Mgmt (2003-2014) Please consider the environment before printing this e-mail From: [email protected] [mailto:[email protected]] On Behalf Of Atkinson, Matt T Sent: Tuesday, March 24, 2015 12:06 PM 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. ________________________________ Legal Notice: This email is intended only for the person(s) to whom it is addressed. If you are not an intended recipient and have received this message in error, please notify the sender immediately by replying to this email or calling +44(0) 2083269015 (UK) or +1 866 592 4214 (USA). This email and any attachments may be privileged and/or confidential. The unauthorized use, disclosure, copying or printing of any information it contains is strictly prohibited. The opinions expressed in this email are those of the author and do not necessarily represent the views of 1E Ltd. Nothing in this email will operate to bind 1E to any order or other contract.
