20421292481
77%

Ran 22 Dec 2025 04:25AM UTC

Jobs 1

Files 121

Run time 1min

Badge

Embed ▾

Committed 22 Dec 2025 03:59AM UTC coverage: 76.808% (+0.001%) from 76.807%

Build # 20421292481

Build Type

push

github

Committed by

web-flow

Commit Message

Redefining SP_DATATYPE_INFO and SP_DATATYPE_INFO_100 Procedures via View (#4309)

Babelfish exhibits high CPU consumption during concurrent connection establishment. Investigation reveals this is due to ANTLR parsing overhead. PyODBC connections call sp_datatype_info_100 during connection setup, causing CPU spikes from intensive ANTLR parsing.

Hence we are defining sp_datatype_info and sp_datatype_info_100 to use pre-compiled views instead of directly calling the C helper function. Views are cached and avoid repeated ANTLR parsing, resulting in lower CPU utilization during connection establishment.

We observed performance improvement as below with this view approach:

No. of Concurrent Connections	Current CPU usage with PyODBC	CPU usage after this View Approach	CPU Reduction
100	9.83%	6.72%	3.11%
200	18.51%	11.91%	6.60%
400	31.75%	20.79%	10.96%
600	44.56%	27.22%	17.34%
800	56.35%	21.96%	34.39%

Issues Resolved
BABEL-6184

Authored-by: Rucha Kulkarni ruchask@amazon.com
Signed-off-by: Rucha Kulkarni ruchask@amazon.com

Run Details

52295 of 68085 relevant lines covered (76.81%)

386998.42 hits per line

Jobs

ID	Job ID	Ran	Files	Coverage
1	20421292481.1	22 Dec 2025 04:25AM UTC	121	76.81	GitHub Action Run

babelfish-for-postgresql / babelfish_extensions / 20421292481
77%

README BADGES
x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 20421292481

babelfish-for-postgresql / babelfish_extensions / 20421292481 77%

README BADGES x

Markdown

Textile

RDoc

HTML

Rst

Jobs

Source Files on build 20421292481

babelfish-for-postgresql / babelfish_extensions / 20421292481
77%

README BADGES
x