[Rpm-maint] [rpm-software-management/rpm] Won't new Auto-Vaccum feature in RPM be seen as a major performance regression by some users? (Discussion #3520)

[AnonymousCoward128746]

> SQL internal vacuum is not the same as --rebuilddb, only similar.

```
# sudo sqlite3 rpmdb.sqlite       
SQLite version 3.46.1 2024-08-13 09:16:08
Enter ".help" for usage hints.
sqlite> .timer on
sqlite> VACUUM; # with whatever's in the page cache during normal use
Run Time: real 35.188 user 2.156049 sys 4.612098
sqlite> VACUUM; # now warm
Run Time: real 18.979 user 1.747309 sys 2.954235
sqlite> VACUUM; # after clearing page cache completely (i.e. boot or image spinning up state)
Run Time: real 55.344 user 2.315559 sys 10.610508
```

-- 
Reply to this email directly or view it on GitHub:
https://github.com/rpm-software-management/rpm/discussions/3520#discussioncomment-11854433
You are receiving this because you are subscribed to this thread.

Message ID: <rpm-software-management/rpm/repo-discussions/3520/comments/11854433 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.rpm.org/pipermail/rpm-maint/attachments/20250116/12984e1d/attachment.htm>