[Aptitude-devel] Bug#519906: use a database like MySQL to speed things up
abe at debian.org
Mon Dec 10 23:37:04 GMT 2012
jidanni at jidanni.org wrote:
> Maybe moving the guts to a database like MySQL (in addition to
> xapian?) might speed things up.
It was already annoying and painful enough to have kdepim/akonadi to
pull in a MySQL server on every desktop/workstation with KDE in
Squeeze. (Luckily they fixed that for Wheezy and now allow to choose
at least SQLite instead.)
I don't want to have to install a MySQL server on all my boxes
including netbooks and embedded systems just to be able to use a
curses based package manager!
> Hmmm, true, aptitude would no longer work from a bare bones system.
Another good point.
> But you'll need apt-get anyway
.oO( Because the apt package is essential... )
> on e.g., cellphones with CPUs too tiny for comfortable aptitude use.
Depends. Used aptitude on the OpenMoko. WFM.
Daniel Burrows wrote:
> > I don't know anything about this stuff but Subversion 1.6 uses now sqlite
> > which can be provided by a single header file IIRC.
> SQL databases aren't a panacea. I did a little experimentation a few
> months ago with building an sqlite database containing some of the core
> apt information. It took ages to build and was too slow for practical
> use. (IMO)
Additionally, with SQLite you have to take special measures if you
want to backup them properly -- as with MySQL, too. I don't think it's
a good idea to burden that on every admin who just wants to use
,''`. | Axel Beckert <abe at debian.org>, http://people.debian.org/~abe/
: :' : | Debian Developer, ftp.ch.debian.org Admin
`. `' | 1024D: F067 EA27 26B9 C3FC 1486 202E C09E 1D89 9593 0EDE
`- | 4096R: 2517 B724 C5F6 CA99 5329 6E61 2FF9 CD59 6126 16B5
More information about the Aptitude-devel