Mailinglist Archive: zypp-devel (43 mails)

[Duncan Mac-Vicar Prett <dmacvicar@xxxxxxx>]

If you look at this graph, the problem is not even the database it self, but 
other ZYpp bottlenecks.

For example, filterExtraSupplemments is 5% of the total.
rewriteKernelDeps alone, 1%
Edition::Impl validateVR is another bottleneck

If you just loop the capabilities, it is:
1.95user 0.04system 0:01.99elapsed

Still denormalizing the capabilities made writing faster.

Launching 19.000 packages and capabilities
real    0m20.069s
user    0m15.417s
sys     0m0.252s

Disabling rewriteKernelDeps and other "hacks"
real    0m15.803s
user    0m15.057s
sys     0m0.108s

disabling Edition::Impl::validateVR
(return the same string)
real    0m11.071s
user    0m10.793s
sys     0m0.088s

And so on....

My proposal, we need backdoors here and skip to much regexp validation, we are 
supposed to save only validated data in the db. The CacheStore can take care 
of doing it once.

Duncan