Repository navigation
Commit 1e428b6
perf(server): read a timeline page's payloads in one query
getTimelinePage ran one SELECT per stored item on the page, so a default
t3_thread_read (50 items) cost 50 sequential payload queries. Read them
in one json_each join, as getThreadHistoryPage already does.
Co-Authored-By: Claude Opus 5.5 <[email protected]>1 parent a8bb769 commit 1e428b6
2 files changed
Lines changed: 37 additions & 9 deletions
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
4743 | 4743 | | |
4744 | 4744 | | |
4745 | 4745 | | |
| 4746 | + | |
| 4747 | + | |
| 4748 | + | |
| 4749 | + | |
| 4750 | + | |
| 4751 | + | |
| 4752 | + | |
| 4753 | + | |
| 4754 | + | |
| 4755 | + | |
| 4756 | + | |
| 4757 | + | |
4746 | 4758 | | |
4747 | 4759 | | |
4748 | 4760 | | |
| |||
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
5530 | 5530 | | |
5531 | 5531 | | |
5532 | 5532 | | |
| 5533 | + | |
| 5534 | + | |
| 5535 | + | |
| 5536 | + | |
| 5537 | + | |
| 5538 | + | |
| 5539 | + | |
| 5540 | + | |
| 5541 | + | |
| 5542 | + | |
| 5543 | + | |
| 5544 | + | |
| 5545 | + | |
| 5546 | + | |
| 5547 | + | |
| 5548 | + | |
| 5549 | + | |
5533 | 5550 | | |
5534 | 5551 | | |
5535 | 5552 | | |
| |||
5540 | 5557 | | |
5541 | 5558 | | |
5542 | 5559 | | |
5543 | | - | |
5544 | | - | |
5545 | | - | |
5546 | | - | |
5547 | | - | |
5548 | | - | |
5549 | | - | |
5550 | | - | |
5551 | | - | |
| 5560 | + | |
| 5561 | + | |
5552 | 5562 | | |
5553 | 5563 | | |
5554 | 5564 | | |
5555 | 5565 | | |
| 5566 | + | |
| 5567 | + | |
| 5568 | + | |
| 5569 | + | |
| 5570 | + | |
| 5571 | + | |
5556 | 5572 | | |
5557 | 5573 | | |
5558 | 5574 | | |
| |||
0 commit comments