Reducing the metadata queries for some database
- Dominant language
- Java
- Stars
- 51.8k
- Forks
- 4.4k
- Avg merge
- 3d 8h
- Merged PRs (30d)
- 188
Description
Some databases, such as Trino, have an undeniable cost of querying metadata. It is a very bad experience to always see many SQL queries for metadata stuck in the queue
```sql
SELECT TABLE_CAT, TABLE_SCHEM, TABLE_NAME, TABLE_TYPE, REMARKS,
TYPE_CAT, TYPE_SCHEM, TYPE_NAME, SELF_REFERENCING_COL_NAME, REF_GENERATION
FROM system.jdbc.tables
WHERE TABLE_NAME LIKE 'confirmed_revenue' ESCAPE '\'
ORDER BY TABLE_TYPE, TABLE_CAT, TABLE_SCHEM, TABLE_NAME
```
We generally do not change the table structure frequently, so it's nice to cache the metadata for one database.
And refresh it by hand.
And I think the Auto-Complete for sql must be use the local cached metadata.
And it can be configed will be more nice.
Contributor guide
Assessment
This issue has not been assessed yet.