From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 26160 invoked by uid 1002); 24 Jun 2003 22:17:00 -0000 Mailing-List: contact gentoo-dev-help@gentoo.org; run by ezmlm Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-dev@gentoo.org Received: (qmail 19195 invoked from network); 24 Jun 2003 22:17:00 -0000 From: Brian Jackson Organization: brianandsara.net To: gentoo-dev@gentoo.org Date: Tue, 24 Jun 2003 17:16:58 -0500 User-Agent: KMail/1.5.2 References: <200306250000.00937.tclark@telia.com> In-Reply-To: <200306250000.00937.tclark@telia.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200306241716.58107.brian@mdrx.com> Subject: Re: [gentoo-dev] maybe it is time to put portage queries into a database. X-Archives-Salt: 0225c749-6661-48a9-af5c-e22da2603b60 X-Archives-Hash: f1e17e86bc36b7ce8f0cf82857e5426a Totally agree. I have 5 Gentoo boxes at work (probably more soon), and it takes a ridiculously long amount of time to do searches. One thing I would suggest is to develop as an external tool, and once it matures, then shoot for inclusion into portage. another suggestion would be for it to support more than one type of db (sleepycat, postgres, mysql, gdbm for example). If you try to make some postgres zealot put mysql on just to query packages, you are going to get some very unhappy words directed your way. I can try to help also in my spare time. --Brian Jackson On Tuesday 24 June 2003 05:00 pm, Tony Clark wrote: > I wanted to quickly find a package with emerge -s whatever. I noticed that > it seemed to be taking a long time now for basic searches. A couple of > random example are presented below. Now in my case on the machine in > question, it is probably a bit slower than need be as /usr/portage is nfs > mounted but neither the nfs server, this client are what would be called > slow machines and I run 100baset ethernet. > > 12 months ago I thought the search times where acceptable, nowdays they are > pushing it and with the number of packages going into portage sooner rather > than later it is going to be unacceptal. I would also suggest a > centralised server approach using something like mysql as apposed to > localised databases based on berekley or something else. reason being that > a number a ppl are running home lans and they are increasing in popularity > and there is no need to store N machines worth of data. mysql comes to mind > as it is a popular database as there is a good chance that for some other > application it is already running on the network. I know in my case thats > so. > > I know this has been discussed in the past but always put down for reasons > I largely agreed with, but the number of packages and times have changed. > I don't mind helping out with this with some perl etc. What I was thinking > on for the initial implementation would be just to store the information > required for searching. I don't see a need to store all dependcies etc so > the installation process actually becomes database driven. In this case > the queriey times are so short to the actually installation time, no > noticable speed up will take place. > > The floor is open, let the flames begin :) > > tony > -- OpenGFS -- http://opengfs.sourceforge.net Home -- http://www.brianandsara.net -- gentoo-dev@gentoo.org mailing list