Configure Intelligence Server for In-Memory Datasets

To ensure the best performance for your partitioned in-memory datasets, you can configure the following settings for your Intelligence Server:

• Consider increasing the number of database connections that Intelligence Server uses to connect to data sources. When users import data into Intelligence Server's memory, the job to connect to the data source is given a low priority. To allow Intelligence Server to retrieve large datasets, you can increase the number of low-priority database connections that Intelligence Server can make.

  For background information on prioritizing jobs, see Prioritize Jobs. For background information on changing the number of database connections, see Manage Database Connection Threads.

• Consider increasing the maximum time that a database query is allowed to run, to ensure that the Intelligence Server has more time to retrieve large datasets from the data source. For background information on increasing the execution time for database queries, see Manage Database Connection Threads