From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from lists.gentoo.org ([140.105.134.102] helo=robin.gentoo.org) by nuthatch.gentoo.org with esmtp (Exim 4.54) id 1FJB4n-0005g0-9V for garchives@archives.gentoo.org; Tue, 14 Mar 2006 15:04:45 +0000 Received: from robin.gentoo.org (localhost [127.0.0.1]) by robin.gentoo.org (8.13.5.20060308/8.13.5) with SMTP id k2EF3dFV001537; Tue, 14 Mar 2006 15:03:39 GMT Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.196]) by robin.gentoo.org (8.13.5.20060308/8.13.5) with ESMTP id k2EF3cIY007170 for ; Tue, 14 Mar 2006 15:03:39 GMT Received: by nproxy.gmail.com with SMTP id x29so145768nfb for ; Tue, 14 Mar 2006 07:03:35 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=tOCzWnydjTArm3NyWd0o15gY2ai3nx8DzKw1aa9MFuHIPrYuAcmLiDrVwpQYvr7PJ2tYhxoRDIz/grpP82Vzgwr/z1YfU7Xg2Ps40lz4DwXaqPJPqe7wijnocgEe5/n24se1Ad2bzSFbGzZimGm99dT4Bf8WNMlHhJTKtiWe3uQ= Received: by 10.48.49.6 with SMTP id w6mr67259nfw; Tue, 14 Mar 2006 07:03:35 -0800 (PST) Received: by 10.49.29.4 with HTTP; Tue, 14 Mar 2006 07:03:35 -0800 (PST) Message-ID: Date: Tue, 14 Mar 2006 17:03:35 +0200 From: tvali To: gentoo-portage-dev@lists.gentoo.org Subject: Re: [gentoo-portage-dev] Few things, which imho would make portage better In-Reply-To: <4416D6C6.8000502@gentoo.org> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-portage-dev@gentoo.org Reply-to: gentoo-portage-dev@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Disposition: inline References: <4416A4C1.6090903@gentoo.org> <4416D6C6.8000502@gentoo.org> X-MIME-Autoconverted: from quoted-printable to 8bit by robin.gentoo.org id k2EF3cIY007170 Content-Transfer-Encoding: quoted-printable X-MIME-Autoconverted: from 8bit to quoted-printable by robin.gentoo.org id k2EF3dGn001537 X-Archives-Salt: 527c1460-7b86-40c7-942f-069d3f39b46a X-Archives-Hash: 0031176fcbee1592823b33d820766bb3 2006/3/14, Alec Warner : > tvali wrote: > > Ok, i send a lot of them, but hopefully they're interesting :) > > > > I would like to build sql table-structure after getting the > > information and send it into this list here so that you could hek out > > if it has something missing or poorly optimized. PS. i dont like rule= s > > of database normalizing, so my strutures usually have some "hacks" in > > them -- i hope that noone complains about that; normalized structures > > are just dull and optimized only for dumb-user-human-readability, > > which is imho not the biggest virtue of software code. > > Uhhh you don't like normalizing your schemas? Normalizing does two > things, reduces redundant data, and increases database speed as tables > are designed in a manner that minimalizes merging time. I will consider what you sayd about db app design. Anyway, i usually try to keep tables more dynamic and look at task at hand, trying to make tables specially for it. When i tested normalizing, i got about 60 tables where i had 5 without normalizing. I didnt build both and test speed, but i have believed that indexing tables makes them fast, too. In that specific case about 40 of those tables were very similar and i did join them a bit and made some multifunctinal fields, others were about connections between tables, which i did put into one table. In that case, which i am talking about, code, which used those tables, were just a lot simpler and shorter, when tables were built in such way, also i didnt have to fear that when i need to do mixed searches or other things like that, code gets complex. I think that looking database structures without considering normalizing rules gives much -- only this db app optimization, which you mentioned, may really make normalized tables better in some cases (and i still hope that there is a way out as i couldnt understand, why one makes such a powerful language as SQL just to deny most of it's beauty afterwards :D). > Running with a schema you pulled out of your ass is likely to give poor > database performance. > > -Alec Warner > > > -- tvali (e-mail: "qtvali@gmail.com"; msn: "qtvali@gmail.com"; icq: "317-492-912") =DChe eesti internetifirma lehel kohtasin tsitaati: If you don't do it excellently, dont do it at all. Because if it's not excellent, it won't be profitable or fun, and if you're not in business for fun or profit, what the hell are you doing here? Robert Townsend --=20 gentoo-portage-dev@gentoo.org mailing list