Re: Proposed SQL schema rev2

Of course. I didn't include the indecies in that, 
since it's just a first run. The key is going to 
be indexing the dependencies and channel packages, 
because those will be the largest and most 
frequently searched.

Kevin - The Alchemist - Sonney wrote:

> 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. 
> 
>