On Wednesday 26 October 2005 06:49, Billy Holmes wrote: > John Myers wrote: > > filenames | 381,200 | 27.1M > > are you storing the full pathname here? yes, but see below
> if you broke up the path in another table, and referenced that to the > basename, you could probably save lots of space - especially since most > applications install lots of files in a limited number of directories. It would save a lot of space proportional to the number of unique filenames, but it wouln't really matter in practice. Each filename is only ever stored once, so over time, the largest tables are actually going to be the unique files table and the file->install map. It would also require many more queries to execute
pgp0Yr33VOwO7.pgp
Description: PGP signature
