Why is the project detailed search much slower than the request search?

  • KM03756615
  • 30-Oct-2020
  • 30-Oct-2020

This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.

Summary

.

Question

Sometimes when searching for projects from particular project type and we used the "Detailed Search" option it takes a lot of time to load results or even times out.

If we search using the request search for the same request type that the project type uses, the search shows results really quick.

Answer

When the Detailed Search is invoked, PPM will try to pull information from a lot more tables and a lot more queries will be used, which will slow the search.

Since more SQL queries are used and more records are accessed by the Detailed Search function, it takes more time than the normal request search functions.

The time also depends on how many projects are expected to be returned.