On 6/3/05, Jason Tackaberry <[EMAIL PROTECTED]> wrote: > On Fri, 2005-06-03 at 17:56 +0200, Martijn Voncken wrote:
> You'll want to use a separate table for directories and use the dirid in > this table rather than include the dirname in the path field. Use a > TEXT field that holds just the filename, rather than full path name. > This saves a lot of space in the database (for very large collections) Your comments are appreciated. It makes some simple things more complex, but i do agree on scalability. Thinking about it. (and how to do the simple things) > and also has the benefit of making directory rename operations a matter > of updating just one row. That's not a real concern for me now. Use case? , how would freevo know about dir-renames in the file-system? Cheers, Martijn. ------------------------------------------------------- This SF.Net email is sponsored by: NEC IT Guy Games. How far can you shotput a projector? How fast can you ride your desk chair down the office luge track? If you want to score the big prize, get to know the little guy. Play to win an NEC 61" plasma display: http://www.necitguy.com/?r _______________________________________________ Freevo-devel mailing list Freevo-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/freevo-devel
