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
