* Duncan Mac-Vicar Prett [Jun 20. 2007 12:27]:

On Wednesday 20 June 2007 11:17:29 Klaus Kaempf wrote:

...

Can we do reading the rpm database on demand (if changed externally) only ?

You need to read it at least once to add the resolvables in the pool.

Which seems to take more time than reading resolvables from the (sqlite) cache. So how about 'parsing' (resp. caching) the rpm database to the same database all other resolvables are ? (Together with a time stamp or whatever is needed to detect changes). This way, only the 'refresh' part of libzypp needs to distinguish between repositories with metadata and the rpm database. Applications just init the Repositories (and Pool) without knowing the difference. Klaus -- To unsubscribe, e-mail: zypp-devel+unsubscribe@opensuse.org For additional commands, e-mail: zypp-devel+help@opensuse.org

Stanislav Visnovsky wrote:

Dňa St 20. Jún 2007 13:45 Francis Giannaros napísal:

...

On 6/19/07, Duncan Mac-Vicar Prett wrote:

...

real 0m8.925s user 0m7.880s sys 0m0.688s These results sound really great! Would it perform similarly if there was a lot more metadata to deal with (say, if Factory was added)?

This is using Factory, see the original mail's source configured.

Not really. That was just ruby and filesharing subset (Duncan, right?) I'm getting 20+ secs for the whole factory (see below). Which is also good compared to 40+ like before. But there is still room for optimization. Although i can't estimate what we will make to 10.3. Jano $ ./zypper sl # | Enabled | Refresh | Type | Name | URI --+---------+---------+--------+--------------+---------------------------------------------------------------------------------- 1 | Yes | No | rpm-md | packman | http://packman.iu-bremen.de/suse/10.3/ 1 | No | No | yast2 | factory-yast | http://ftp.opensuse.org/pub/opensuse/distribution/SL-OSS-factory/inst-source 1 | Yes | No | rpm-md | factory-yum | http://ftp.opensuse.org/pub/opensuse/distribution/SL-OSS-factory/inst-source... $ time ./zypper search zypper S | Catalog | Type | Name | Version | Arch --+---------+---------+--------+------------+------- i | | patch | zypper | 2513-0 | noarch i | | atom | zypper | 0.6.15-0.1 | x86_64 i | | package | zypper | 0.7.1-3 | x86_64 v | | package | zypper | 0.7.2-7 | i586 v | | package | zypper | 0.7.2-7 | x86_64 real 0m24.721s user 0m22.817s sys 0m1.148s $ time ./zypper install zypper Reading RPM database... Summary: <uninstall> [S0:0][package]yast2-perl-bindings-2.14.0-33.x86_64 <uninstall> [S0:0][package]zypper-0.7.1-3.x86_64 <uninstall> [S0:0][package]yast2-ncurses-2.15.14-3.x86_64 <install> [S0:0][package]libzypp-3.2.2-15.x86_64 <install> [S0:0][package]yast2-perl-bindings-2.15.1-8.x86_64 <install> [S0:0][package]libstdc++42-4.2.1_20070604-8.x86_64 <install> [S0:0][package]yast2-ncurses-2.15.19-2.x86_64 <install> [S0:0][package]yast2-qt-2.15.5-32.x86_64 <install> [S0:0][package]yast2-pkg-bindings-2.15.20-12.x86_64 <install> [S0:0][package]zypper-0.7.2-7.x86_64 <uninstall> [S0:0][package]yast2-qt-2.15.5-3.x86_64 <uninstall> [S0:0][package]libstdc++41-4.1.3_20070302-3.x86_64 <uninstall> [S0:0][package]libzypp-3.2.0-3.x86_64 <uninstall> [S0:0][package]yast2-pkg-bindings-2.15.15-3.x86_64 Continue? [y/n] n real 0m27.877s user 0m24.082s sys 0m1.308s -- To unsubscribe, e-mail: zypp-devel+unsubscribe@opensuse.org For additional commands, e-mail: zypp-devel+help@opensuse.org

On Wednesday 20 June 2007 01:45:55 pm Francis Giannaros wrote:

On 6/19/07, Duncan Mac-Vicar Prett wrote:

...

real 0m8.925s user 0m7.880s sys 0m0.688s

These results sound really great! Would it perform similarly if there was a lot more metadata to deal with (say, if Factory was added)?

No. But it wont perform as bad as before. What takes time is to build the cache. Like 2 min in my slow machine with 3 repos plus factory. But you can add repos without refreshing inmediately, and you can install without refresh (if you have old metadata). This was the most annoying bug, that sources refreshed when starting up, when deleting, when listing. That is gone. Once the cache is there, with factory it goes up from 8 to 15 seconds to load the resolvables, read rpm and solve plus the time to install the rpms. Note: we haven't done any optimization yet. Duncan -- To unsubscribe, e-mail: zypp-devel+unsubscribe@opensuse.org For additional commands, e-mail: zypp-devel+help@opensuse.org