Tips to Improve Performance of Resource ID Fetching
If you are introspecting a very large data source, you can improve the performance during resource ID fetching by:
• Putting the TDV Server on a machine with many CPUs.
• Increasing the Connection Pool Maximum Size setting in Studio. Open the data source, select the Configuration tab, and select the Advanced tab.
Note: The physical data source might be impacted if this number is too high.
• Allocating additional memory for both TDV Server and Studio if the data source you are introspecting has large amounts of metadata. (Large amounts of data do not matter.) To do this, increase the memory settings in these Studio configuration parameters: Privilege Cache Size (On Server Restart) and Metadata Cache Size (On Server Restart).
Note: Do not request that a second cache be built while the initial cache of resource IDs is being built. If you do this, TDV does not attempt to merge these requests; instead the work is duplicated in parallel.