Re: Proposed SQL schema rev2

Kevin - The Alchemist - Sonney <[email protected]>
Newsgroups gmane.network.up2date.current.devel
Message-ID <[email protected]>
On Fri, 2002-02-01 at 19:13, Todd Nemanich wrote:
> 	Attached is a file containing the statements needed 
> to create a simplified version of the schema I 
> proposed. Packagers, package_layers, checksums, 
> and devices have been cut as per Hunter's request. 

This looks pretty good to my review. I'd consider indexing some of the
likely lookup targets - especially on packages, package_files, and
dependencies - as those have the potential to be very large tables, and
be the most likely place for slowdowns during lookups. 

-- 
--------------------------------------------
--      Kevin "The Alchemist" Sonney      --
--  ICQ: 4855069            AIM: ksonney  --
--------------------------------------------
320C 0336 3BC4 13EC 4AEC  6AF2 525F CED7 7BB6 12C9
signature.asc (application/pgp-signature, 232 B)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQA8W0xjUl/O13u2EskRAiQLAJ0UWuLXlkxW5ne+1Zr7BN2nhWEOKQCgluul
v8ImDqXqcu52t7g7nSsK0Us=
=S0f8
-----END PGP SIGNATURE-----
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.