Database Question

From: Date: Wed, 20 Dec 2006 07:01:29 +0000
Subject: Database Question
Groups: php.general 
Request: Send a blank email to php-general+get-246057@lists.php.net to get a copy of this message
Someone's going to tell me to go buy a book, I just know it. I'll ask anyway: I'm starting to log weather data to a database and I'm trying to figure out what's the best way to create the tables. The reports are coming in every minute, of every hour, 24 hours a day. Eventually, I'd like to do some calculations on the statistics, displaying daily values (which can be broken down to hourly), but then also daily and monthly averages. To me, it doesn't make sense to dump everything into one big table, but I can't figure out what's the best way to break it down either. Keep in mind that the only data I have, is what comes in for that minute. The daily averages I have to calculate myself (later.) But I can't see one large table being very effective when it comes to calculating that stuff. So, how should I break the tables down? Create a new table every day (20061219_data, 20061220_data, etc.) and insert all the values in it? Or, break it down per values (temp_table, humidity_table, etc.) and insert daily data in them? -- A

« previous php.general (#246057) next »