On Sun, 2005-08-21 at 21:05 +0200, Dirk Meyer wrote: > We we also add a generic key/value table, we should make sure we > select this data for a File only when needed.
I think this generic key/value table would only be used in cases where an existing file has a user-added attribute name (i.e. something that's specific to one or just a few files, not all files of that type). I really don't think this is a very common thing. If we add an index to the attribute name in this generic metadata table, doing a query on this table for an attribute name that doesn't exist should be very fast. Moreover, for most users, this table wouldn't be very big. But as I said in my last email, I think we shouldn't worry about this right now. I'm pretty sure we can add this sort of thing later without changing the design DBOverlord uses. Jason.
signature.asc
Description: This is a digitally signed message part
