about summary refs log tree commit homepage
path: root/lib/PublicInbox/V2Writable.pm
diff options
context:
space:
mode:
authorEric Wong <e@80x24.org>2021-10-11 08:06:15 +0000
committerEric Wong <e@80x24.org>2021-10-12 03:40:28 +0000
commitc4a4e9809ddd10f2094e1b088728101ace89297f (patch)
treed5c07be0090d45ed75137adee1067b3735d19fa7 /lib/PublicInbox/V2Writable.pm
parentc9567f1e142931cf4c5f092ad1ec5904f7c5bdc1 (diff)
downloadpublic-inbox-c4a4e9809ddd10f2094e1b088728101ace89297f.tar.gz
This required some tweaking of xref3 indices in over.sqlite3,
but the end result is it brings no-op "--reindex --fast --all"
checks down to roughly 20 minutes (from 30-40 minutes) on
lore/all.

This is faster because a bunch of small SQLite queries are still
slower en-mass than a bunch of perlops.  Despite the lack of IPC
overhead, crossing .so boundaries and repeating lookups over
btrees is still slower than doing the same with Perl hash tables.
Diffstat (limited to 'lib/PublicInbox/V2Writable.pm')
0 files changed, 0 insertions, 0 deletions