Skip to main content
Solved

Connect AI Missing Tables and Columns

  • March 20, 2023
  • 1 reply
  • 215 views

Om D
Forum|alt.badge.img

I am trying to query my sources in CData Connect AI but they are running slow. They used to run instantly.

What can I do to return to the speed the queries were running with?

Best answer by Om D

Occasionally, the Metadata Cache can fill up causing issue with speed, performance, and causing issues that do occur originally. 

Clearing the Metadata Cache can resolve these issues. Your connections, saved queries, and Derived Views will not be cleared.

To clear the cache for the data source you’re having issues with, please navigate to the connection on the Sources page. There should be an option to "Clear Metadata" near the Delete and Save & Test buttons. Please select this option to clear the data source’s cache and resolve any performance issues you may have faced.

 

This topic has been closed for replies.

1 reply

Om D
Forum|alt.badge.img
  • Author
  • Employee
  • Answer
  • March 20, 2023

Occasionally, the Metadata Cache can fill up causing issue with speed, performance, and causing issues that do occur originally. 

Clearing the Metadata Cache can resolve these issues. Your connections, saved queries, and Derived Views will not be cleared.

To clear the cache for the data source you’re having issues with, please navigate to the connection on the Sources page. There should be an option to "Clear Metadata" near the Delete and Save & Test buttons. Please select this option to clear the data source’s cache and resolve any performance issues you may have faced.