Date: Mon, 14 May 2007 17:48:38 +0100 From: Tom Evans <tevans.uk@googlemail.com> To: 'Michel Talon' <talon@lpthe.jussieu.fr> Cc: freebsd-hackers@freebsd.org, Thomas Sparrevohn <Thomas.Sparrevohn@btinternet.com> Subject: Re: DPS Initial Ideas Message-ID: <1179161318.1791.32.camel@zoot.mintel.co.uk> In-Reply-To: <20070514082512.GA25544@lpthe.jussieu.fr> References: <20070514082512.GA25544@lpthe.jussieu.fr>
next in thread | previous in thread | raw e-mail | index | archive | help
--=-K/AQ0H1P/bytlceJUNlx Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable On Mon, 2007-05-14 at 10:25 +0200, 'Michel Talon' wrote: > On Mon, May 14, 2007 at 12:33:23AM +0100, Thomas Sparrevohn wrote: > >=20 > > converted INDEX > > into postgresSQL because I was playing around with making a message que= ue > > based approach - > > and it becomes BIG - The only table structure difference from the curre= nt > > format was that I=20 > > was able to track "who is depending on" a port - which I am pretty sure > > could be handled in the > > current framework - e.g. we could add a file having the depending port = names > > or so >=20 >=20 > niobe% cp /usr/ports/INDEX-6 . > niobe% sqlite3 index.db > sqlite> CREATE TABLE index6 ( > pkgname varchar(1), > path varchar(1), > prefix varchar(1), > comment varchar(1), > descr varchar(1), > maintainer varchar(1), > categories varchar(1), > build_deps varchar(1), > run_deps varchar(1), > website varchar(1), > extract_deps varchar(1), > patch_deps varchar(1), > fetch_deps varchar(1)); > sqlite> .import INDEX-6 index6 > ... completes in less than 2 seconds > sqlite> select * from index6 where path =3D "/usr/ports/accessibility/atk= "; > atk-1.12.4|/usr/ports/accessibility/atk|/usr/local|A GNOME accessibility > toolkit > (ATK)|/usr/ports/accessibility/atk/pkg-descr|gnome@FreeBSD.org|accessibil= ity > devel|gettext-0.14.5_2 glib-2.12.9 libiconv-1.9.2_2 libtool-1.5.22_3 > perl-5.8.8 pkg-config-0.21|gettext-0.14.5_2 glib-2.12.9 libiconv-1.9.2_2 > perl-5.8.8 > pkg-config-0.21|http://developer.gnome.org/projects/gap/||libtool-1.5.22_= 3| >=20 > niobe% ls -lh INDEX-6 index.db=20 > -rw-r--r-- 1 michel lpthe 9,5M 14 mai 10:00 INDEX-6 > -rw-r--r-- 1 michel lpthe 12M 14 mai 10:12 index.db >=20 > Where is this huge increase in size? > Admittedly, i have not created indexes, etc. ^^^^^^^^^^^^^^^^^^^^^^^^^^ > Compare this to the portsdb created by portupgrade from the same INDEX-6 >=20 > niobe% ls -lh /usr/ports/INDEX-6.db > -rw-r--r-- 1 root wheel 21M 16 f=C3=A9v 13:36 /usr/ports/INDEX-6.db >=20 > Surprise, surprise, the BerkeleyDB suddenly appears less glorious. Your index has no indices, and you wonder why it is smaller? --=-K/AQ0H1P/bytlceJUNlx Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (FreeBSD) iD8DBQBGSJLmlcRvFfyds/cRAgUZAJkBLHMhINAoc19f9X6dEha8gq21mgCeImNY 7dGUv7+V53R4tSe0mhRdoOI= =BjY1 -----END PGP SIGNATURE----- --=-K/AQ0H1P/bytlceJUNlx--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1179161318.1791.32.camel>