Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"

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 the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (7)
As of 2015-11-28 01:13 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (737 votes), past polls