Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change

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

by jimbus (Friar)
on Apr 17, 2007 at 14:18 UTC ( #610529=note: print w/replies, xml ) Need Help??

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


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 :)

--Jimbus aka Jim Babcock
Wireless Data Engineer and Geek Wannabe
  • Comment on Re^2: Of Mysql, DBI and PK best practices

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://610529]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (2)
As of 2017-04-30 12:32 GMT
Find Nodes?
    Voting Booth?
    I'm a fool:

    Results (537 votes). Check out past polls.