Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
None
-
None
Description
System Catalog columnRIDs is quite slow when there are many columns in an installation. When iterating over a table this takes a very long time to execute and populate. This matters for information_schema and mcsapi.
Proposed changes:
1. system catalog should not flush the entire cache on a single table change, just the table that changed
2. tableinfo() call to columnRIDs should use cache
3. for information_schema and mcsapi there should be a call that retrieves the entire catalog without the filter conditions instead of lots of loops that we do at the moment.
4. mcsapi (in DBRM's doGetSystemCatalog) we should switch to FE mode:
systemCatalogPtr->identity(execplan::CalpontSystemCatalog::FE);
|
Attachments
Issue Links
- includes
-
MCOL-1484 Use condition pushdown in I_S tables
- Closed