12375791491
74%
BABEL_5_X_DEV: 77%

Ran 17 Dec 2024 03:57PM UTC

Jobs 1

Files 114

Run time 1min

Badge

Embed ▾

Committed 17 Dec 2024 03:09PM UTC coverage: 73.78% (-0.003%) from 73.783%

Build # 12375791491

Build Type

push

github

Committed by

web-flow

Commit Message

Optimize DDL export framework execution time (#3266)

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

43103 of 58421 relevant lines covered (73.78%)

147469.76 hits per line

Uncovered Existing Lines

Lines	Coverage	∆	File
2	76.03	-0.63%	contrib/babelfishpg_tds/src/backend/tds/tdscomm.c

Jobs

ID	Job ID	Ran	Files	Coverage
1	12375791491.1	17 Dec 2024 03:57PM UTC	114	73.78	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 12375791491
74%
BABEL_5_X_DEV: 77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 12375791491

babelfish-for-postgresql / babelfish_extensions / 12375791491 74% BABEL_5_X_DEV: 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Uncovered Existing Lines

Jobs

Source Files on build 12375791491

babelfish-for-postgresql / babelfish_extensions / 12375791491
74%
BABEL_5_X_DEV: 77%

README BADGES
x