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