Also keep in mind that unless you have parallel processing turned off for the query or multiprovider, and/or filter on the InfoProvider within the query, it will launch query against each InfoProvider within the MultiProvider concurrently.
With 10 Infoproviders in a MultiProvider, 10 queries could be launched simultaneously. If 4 people all run the query around the same time, you could now have 40 queries running concurrently. It is easy to overload the server. I think I have seen some notes for 3.1 SP 21 that provide some options to limit the maximum nbr of processes that a MP could launch, to avoid overloading the server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.