https://bugzilla.novell.com/show_bug.cgi?id=332239#c1 --- Comment #1 from Andras Mantia 2007-10-09 09:31:00 MST --- Created an attachment (id=177143) --> (https://bugzilla.novell.com/attachment.cgi?id=177143) Yast logs -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=332239 Ladislav Slezak changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|lslezak@novell.com |dmacvicar@novell.com Component|YaST2 |libzypp QAContact|jsrain@novell.com |dmacvicar@novell.com -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=332239#c3 --- Comment #3 from Andras Mantia 2007-10-11 12:07:58 MST --- Here are my test results. The difference is that I changed my CPU to a dual-core Opteron, the rest of the system is the same. I didn't know what zypper command to use, so I used "zypper lu" as Marcus Meissner did. During the test the network was brought down, to avoid downloading updates (in YaST this meant clicking OK & Skip). In YaST I counted the time from when I click on the Software Management icon until all messages/dialog boxes disappear, so I can use it: 1) Cold cache, PC rebooted: - YaST - 1st run: 1 minute 30 seconds - YaST - following runs: 38 seconds - zypper lu (after running YaST for a few times): real 0m7.843s user 0m6.592s sys 0m1.180s 2) Cleaning the sqlite database as suggested: - YaST: 37 seconds - zypper lu: real 0m7.330s user 0m6.200s sys 0m1.144s 3) Rebuild the RPM database: - YaST: 34 seconds - zypper lu: real 0m7.938s user 0m6.616s sys 0m1.288s 4) Brought the network up, so I don't click inside YaST: - YaST: 40 seconds - zypper lu: real 0m15.954s user 0m14.057s sys 0m1.908s Here is the complete output of the last zypper lu command: time zypper lu * Reading repository 'openSUSE BuildService - KDE:Community' cache * Reading repository 'openSUSE BuildService - Games (action)' cache * Reading repository 'Main Repository (OSS)' cache * Reading repository 'openSUSE BuildService - KDE:Backports' cache * Reading repository 'Education:desktop' cache * Reading repository 'Packman Repository' cache * Reading repository 'openSUSE-10.3-DVD 10.3' cache * Reading repository 'Main Update Repository' cache * Reading repository 'NVIDIA Repository' cache * Reading repository 'openSUSE BuildService - X11:XGL' cache * Reading repository 'openSUSE BuildService - Wine CVS Builds' cache * Reading installed packages [100%] Repository: | Name | Version | Category | Status -----------------------+--------------------+---------+-------------+------- Main Update Repository | hugin | 4518-0 | security | Needed Main Update Repository | kernel | 4503-0 | security | Needed Main Update Repository | km_drm | 4484-0 | security | Needed Main Update Repository | libiniparser-32bit | 4488-0 | optional | Needed Main Update Repository | smartmontools | 4517-0 | recommended | Needed Main Update Repository | zypper | 4530-0 | recommended | Needed real 0m15.954s user 0m14.057s sys 0m1.908s So yes, zypper is much faster in all cases. None of the suggested speedups did really help with zypper, but it helped a little with YaST. But with YaST the startup is still slow. With cold cache it is VERY slow. Let me know what kind of tests (or logs/outputs) you would like to see. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=332239#c5 Andras Mantia changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |NEW Info Provider|amantia@kde.org | --- Comment #5 from Andras Mantia 2007-10-11 12:49:06 MST --- And the last one after a reboot, now starting with zypper (network is up): first run: real 0m45.953s user 0m13.549s sys 0m1.784s second run: real 0m14.940s user 0m13.397s sys 0m1.528s yast: 39 seconds -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=332239#c7 --- Comment #7 from Andras Mantia 2007-11-09 06:05:56 MST --- Closing a report because you *might* make speed improvements in the next release is weird, but this isn't the only time I see such thing in openSUSE bug management. :( In normal case I'd close this report once the 11.0 version *is* available (at least in factory) and it fixes the slowness. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=332239 Duncan Mac-Vicar changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|dmacvicar@novell.com |ma@novell.com Status|REOPENED |NEW Component|libzypp |libzypp Product|openSUSE 10.3 |openSUSE 11.0 Version|Final |unspecified -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=332239 Ivan G Shevchenko changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks| |346630 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=332239 User linuxadmin@yandex.ru added comment https://bugzilla.novell.com/show_bug.cgi?id=332239#c11 --- Comment #11 from Ivan G Shevchenko 2007-12-16 07:49:57 MST --- from the duplicate bug 346630: I have a subjective impression, that the performance of the process is anti-proportional to the amount of changes (in each repository). Isn't it possible, just to DELETE the cache of a changed repository? (Therefor, each repo would need own DB) -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=332239 User dmacvicar@novell.com added comment https://bugzilla.novell.com/show_bug.cgi?id=332239#c12 --- Comment #12 from Duncan Mac-Vicar 2007-12-16 13:53:04 MST --- Yes, that is being working on for next version, but using a different format for the cache. sqlite is pretty bad at fragmentation, and we should had kept the repositories separated. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

https://bugzilla.novell.com/show_bug.cgi?id=332239 User ma@novell.com added comment https://bugzilla.novell.com/show_bug.cgi?id=332239#c14 Michael Andres changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED --- Comment #14 from Michael Andres 2008-04-15 04:34:56 MST --- IMO we can close this, as 11.0 is a bit faster. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.