[pm-h] complex data structure help
Paul Archer
tigger at io.com
Tue Mar 28 10:42:39 PST 2006
11:31am, Paul Archer wrote:
>
> Maybe a simple format:
>
> filesystem user client-machine time-to-the-hour read written
>
> Then for every line, I check to see if I have an entry that matches the
> first four parameters. If so, I add the number of bytes read or written. If
> not, I create a new entry. Then I can sort by whatever field I want, and
> limit my searches however I need to.
>
> Only that seems inefficient. Could I normalize that somehow?
>
> Paul
>
I talked this over with a coworker. He suggested one table each for users,
client machines, and filesystems, just for lookups. Then one table for a
combination of the three, and one table for timeperiods with the bytes
written or read for each time period.
I think that'll work...
More information about the Houston
mailing list