Help working out how to process data

[jiggles]

Hi,

I forgot I was a member here! Please forgive!

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! :o 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! =/

[astonecipher]

The only thing I would suggest modifying is your criteria for adding a row. If the printer should be up, only add a record when it is down and even then, only check once a minute instead of every ten seconds. From there you could determine up/ down time.

[jiggles]

I was thinking like that but I don’t want to use crons. The only way of getting to know when the printer is on is when it polls. I have no way of pinging the printer (Which make life easy! Not.)