Fra: Nick Arnett [mailto:[EMAIL PROTECTED]]
Sendt: 3. maj 2002 04:30
Emne: Strategies for maintaining tables calculated from other tables?
I'm finding that it's not quite as simple as I had imagined to maintain a
table whose values are calculated by analyzing other tables. The source
I'm also curious what solutions others have arrived at for this.
I currently have a similar situation to what you are describing: I've got a
large database of timestamped log entries, and need to generate periodic
summaries over them, but don't want to actually mine the entire huge
database
MySQL has a column type for that, so you don't have to use an INT or BIGINT:
http://www.mysql.com/doc/S/E/SET.html
--jeff
- Original Message -
From: Harald Fuchs [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 03, 2002 4:19 AM
Subject: Re: Strategies for maintaining tables
I'm finding that it's not quite as simple as I had imagined to maintain a
table whose values are calculated by analyzing other tables. The source
tables contain time series data, which can is updated several times a day.
To calculate totals by day, week, month, etc., I don't want to have to