When you enable the Data Integration Service to use cached results, data service performance increases. However, to further improve the data service processing time for identical queries, allocate enough space to store the cache in memory. When you configure the amount of cache memory to be equal to or greater than what is required to cache the results, you increase performance by reducing the system I/O overhead. When the Data Integration Service writes cache files to disk, the data service processing time increases due to system I/O overhead.