[source-ms-sql] - Running a Select TOP 1024 with no filter
- Ngôn ngữ chính
- Python
- Star
- 22.1k
- Fork
- 5.3k
- Chỉ số merge pull request
- Chỉ số pull request đang chờ
Mô tả
### Connector Name
source-mssql
### Connector Version
4.3.5
### What step the error happened?
None
### Relevant information
My builds have slowed down significantly since upgrading to 4.3.5.
I have a table syncing on Incremental | Dedupe
For some reason a select TOP [column names] from [table] order by [column name] is occurring which is taking a very long time to run on my large table.
### Relevant log output
```shell
2026-03-16 14:11:36 source INFO DefaultDispatcher-worker-1#rpt.test-round-1-create-partitions i.a.c.r.JdbcSelectQuerier$Result(hasNext):117 Received results from server.
2026-03-16 14:11:36 source INFO DefaultDispatcher-worker-1#rpt.test-round-1-create-partitions i.a.c.r.JdbcSelectQuerier$Result(close):173 Closing SELECT MAX([DateTime]) FROM [rpt].[test]
2026-03-16 14:11:36 source INFO DefaultDispatcher-worker-1#rpt.test-round-1-create-partitions i.a.c.r.JdbcPartitionsCreator(ensureCursorUpperBound):96 Maximum cursor column value in 'rpt.reporting_Reconciliation' is '"2026-03-16T03:03:41.067000"'.
2026-03-16 14:11:36 source INFO DefaultDispatcher-worker-1#rpt.test-round-1-create-partitions i.a.c.r.JdbcPartitionsCreator(collectSample):108 Sampling stream 'rpt.test' at rate 1 / 65536.
2026-03-16 14:11:36 source INFO DefaultDispatcher-worker-1#rpt.test-round-1-create-partitions i.a.c.r.JdbcSelectQuerier$Result():76 Querying SELECT TOP 1024 COLUMNS HERE FROM [rpt].[test] ORDER BY [DateTime]
2026-03-16 14:11:36 source INFO DefaultDispatcher-worker-1#rpt.test-round-1-create-partitions i.a.c.j.JdbcConnectionFactory(get):44 Creating new connection for 'jdbc:sqlserver://############'.
```
### Contribute
- [ ] Yes, I want to contribute
---
**Internal Tracking:** https://github.com/airbytehq/oncall/issues/11627
Hướng dẫn đóng góp
Đánh giá
Issue này chưa được đánh giá.