Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

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]
[vickycanada]: Hi, Can anyone please help me with this - 1203954
[vickycanada]: #1203954

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (5)
As of 2017-11-21 21:48 GMT
Find Nodes?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:

    Results (312 votes). Check out past polls.