mrjiggles

Just away of using the dates and times of when the device last polled to create uptime and down time charts. Also ways of stopping this from making a database table HUGE! I worked out if I have a 100 of these devices on one day I would have over 1.4million rows! That could get ugly quickly. Never mind putting out the data in a nice format... I'm normally good at working out issues and problems but this one has me totally confused.

Hi, I need to rack some peoples brains! I have here a script that allows a GSM/ Remote receipt printer to poll for data in a specific format. The issue is that I will be deploying a few 100 of these damn things and need to know what ones are on or off! I can get the time I polls the file and have it writing to a DB table. The only issue is that even with only two printers running its filling up the table fast! Over 600 rows in 30 mins for only two printers! I need to find out a better way to do this but have the same flexibility in knowing what exact times it was on and off and then to take this data and put into a nice viewable format! This should be safe with a few hundred printers at once. Hope someone can help me with this as I am totally stumped! =/

Hi, I'm Callum and I thought I would be the nice one and post a Hi!