After several beta upgrades I had it at RC1 level and tested online updates.
$ time zypper lu real 3m4.187s user 0m31.306s sys 0m3.440s
Boringly long and it hits the disk constantly. Lets see the size of the zypp.db sqlite cache ... 80 MB (wtf? for the whole 10.3 repo + 2 times the update repo?)
Also the rpm database is 40MB for Packages, and another 10MB for the filelist (why?).
So what can we do:
Defragment on the disk
Due to repeated increase the file is fragmented on the disk. Not good for seek patterns.
The easiest way to fix this is to:
cp file file.new ; rm file ; mv file.new file
The full file copy defragments the file nearly by itself.
So doing this for the large zypp.db, Packages and the Filenames and Dirnames of /var/lib/rpm we
$ time zypper lu real 2m40.794s user 0m31.242s sys 0m3.400s
24 seconds saved.
Clean up the zypp.db cache
There is internal fragmentation in the zypp.db, partially caused by repos I had added and now
removed, partially due to refreshes.
So we run:
sqlite3 /var/cache/zypp/zypp.db vacuum
It is now 29 MB.
Alternatively you can also just rebuild it from scratch, which will give the same result
rm /var/cache/zypp/zypp.db ; zypper refresh
fragmentation of RPM Packages DB
The RPM DB also seems to get internally fragmented, the "reading packages" takes very long.
Now the time is:
$ time zypper lu real 2m2.523s user 0m30.582s sys 0m3.400s
And defragment it again (cp Packages Packages.new; rm Packages; mv Packages.new Packages)
$ time zypper lu real 1m7.278s user 0m32.730s sys 0m3.160s
Just 2 minutes of 3 saved, and just a 200% speed up.
And SDBized: http://en.opensuse.org/SDB:Speed_up_Pac