dolthub / dolthub/dolt

With `dolt_transaction_commit=1`, large latency for `START TRANSACTION` and `SET TRANSACTION ISOLATION LEVEL SERIALIZABLE`.

Open
#5,704 5 comments 0 reactions 0 assignees View on GitHub
performance sql
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 5h
Merged PRs (30d)
108

Description

On hosted instance running Dolt `v0.75.9`, seeing unexpectedly large query latency times for what should be almost instant queries:
```
2023-04-06T17:06:37Z DEBUG [conn 1074] Query finished in 1752 ms {connectTime=2023-04-06T16:29:49Z, connectionDb=dolthubapi, query=SET TRANSACTION ISOLATION LEVEL SERIALIZABLE}
```
```
2023-04-06T17:06:37Z DEBUG [conn 1080] Query finished in 1726 ms {connectTime=2023-04-06T16:29:50Z, connectionDb=dolthubapi, query=START TRANSACTION}
```

These times can be as low as < 50ms, or as high as the above.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.