diff options
| author | Eric Wong <e@80x24.org> | 2021-10-11 08:06:15 +0000 |
|---|---|---|
| committer | Eric Wong <e@80x24.org> | 2021-10-12 03:40:28 +0000 |
| commit | c4a4e9809ddd10f2094e1b088728101ace89297f (patch) | |
| tree | d5c07be0090d45ed75137adee1067b3735d19fa7 /lib/PublicInbox/Over.pm | |
| parent | c9567f1e142931cf4c5f092ad1ec5904f7c5bdc1 (diff) | |
| download | public-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/Over.pm')
| -rw-r--r-- | lib/PublicInbox/Over.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/PublicInbox/Over.pm b/lib/PublicInbox/Over.pm index 98de82c0..30ad949d 100644 --- a/lib/PublicInbox/Over.pm +++ b/lib/PublicInbox/Over.pm @@ -108,8 +108,8 @@ sub do_get { } sub query_xover { - my ($self, $beg, $end) = @_; - do_get($self, <<'', {}, $beg, $end); + my ($self, $beg, $end, $opt) = @_; + do_get($self, <<'', $opt, $beg, $end); SELECT num,ts,ds,ddd FROM over WHERE num >= ? AND num <= ? ORDER BY num ASC |