Re^2: Of Mysql, DBI and PK best practices

[jimbus]

in reply to Re: Of Mysql, DBI and PK best practices
in thread Of Mysql, DBI and PK best practices

Dragonchild,

I was deliberately being 'data neutral' to keep focus on the mechanics... The PK is a date-time based on yyyy-mm-dd hh::00:00 and the information comes from multiple nodes from one system. In the end, I need a report on the usage of all of the nodes and the total for the system based on time. Additionally, log files are 'line count' based, so hours often overlap the files which are processed every 15 minutes.

However, thanks for taking the time :)