Data aquisition problem / feature

[sparkx]

I am trying to develop on arduino (www.arduino.cc or remote linux box) a remote weather station.
Since arduino is connected to the internet on random ip the only feasable ideea to transfer data to the cacti_box is to call cacti_box and transfer values from the readings in the address with HTTP_GET (arduino accesses http://cacti_box.com/collect_data.php?temp1=1&temp2=2&temp3=3) then a php script takes the values from the variables in the link and does something with them (inserts them into mysql, writes them to a file, etc.)

What I have described since now is easy to do but which is the best solution becouse the table if I go with mysql will grow very large very quickly and if I go with a file I will have the problem of parsing data and file size, etc.

I can make a script to read last row from a file and get data, but what happends when the data is not updated between readings, how can I avoid reading the same data many times in a row?

Please point me to the wright direction.

sparkx

[gandalf]

You may want to provide a time stamp for comparison
R.