12375786177
76%
BABEL_5_X_DEV: 77%

Ran 17 Dec 2024 03:44PM UTC

Jobs 1

Files 115

Run time 1min

Badge

Embed ▾

Committed 17 Dec 2024 03:09PM UTC coverage: 74.834%. Remained the same

Build # 12375786177

Build Type

push

github

Committed by

web-flow

Commit Message

Optimize DDL export framework execution time (#3265)

Previously, the DDL export framework was taking over 20 minutes to run the ddl_all_objects.sql test, while other tests completed within a minute. Upon further investigation, we found that we were not filtering out objects in the 'sys' schema before checking IsSystemObject. This resulted in executing a query for each object present in the 'sys' schema to determine whether it was a system object or not.

This commit adds a schema filter before the IsSystemObject check in the SMO script. By first excluding objects in the 'sys' schema, we avoid unnecessary IsSystemObject checks on system objects, significantly reducing execution time of framework.

Task: BABEL-5473

Signed-off-by: Sumit Jaiswal <sumiji@amazon.com>

Run Details

46606 of 62279 relevant lines covered (74.83%)

164931.06 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	12375786177.1	17 Dec 2024 03:44PM UTC	115	74.83	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 12375786177
76%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12375786177

babelfish-for-postgresql / babelfish_extensions / 12375786177 76% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 12375786177

babelfish-for-postgresql / babelfish_extensions / 12375786177
76%
BABEL_5_X_DEV: 77%

README BADGES
x