Problem: developers can't get node PR checks back within an hour #1445

A node pull request that touches the stream or bridge tests runs the slow integration tests, and so does every merge to main. A normal run takes about two and a quarter hours. About one run in ten stalls for two hours and then starts over, which puts the checks at four to five hours. The order book action for this Goal waited four hours on its checks:

• feat: read a market's volume and traders from the node #1444

I measured where the time goes, and most of it is test setup rather than the tests themselves. The fixes go into kwil-db first, then into the node CI workflow.

Outcome

The slow integration tests on a node pull request finish within an hour, and a stalled run fails within minutes instead of two hours.

Part of:

• Goal: SDK call for market volume over a time period #1429