Skip to content

Allow to exclude system/non-user tables #5764

@mvorisek

Description

@mvorisek

Feature Request

this is a result of investigation of #5698

Q A
New Feature yes
RFC no

Summary

in atk4/data we are excluding Oracle system tables by extending the OraclePlatform::getListTablesSQL method

https://github.com/atk4/data/blob/0c6bce5c2ac53589934b02bc0832a4753c283f15/src/Persistence/Sql/Oracle/PlatformTrait.php#L111-L119

we do so to massively improve the discovery performance as listing the system/non-user table is not helpful

in DBAL 3.3 this reduced the tests time from hours to about 2 minutes

in DBAL 3.4.x #5268 was introuced, which reduced the time, without the custom OraclePlatform::getListTablesSQL method override described above, to about 8 minutes

this is a feature request to filter the oracle_maintained tables (and objects in general) out by default and/or to provide an option in schema manager to enable/disable such filtering

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions