Re: Tracking changes in large datasets over time

2008-07-20 Thread Rob Wultsch
On Sat, Jul 19, 2008 at 4:18 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > On Fri, Jul 18, 2008 at 3:46 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: >> I'm sure there is a way to write this in a single query, but I bet it >> it is ugly as heck, probably with a bunch of derived tables. > > INSERT INTO

Re: Tracking changes in large datasets over time

2008-07-20 Thread Jake Peavy
On 7/19/08, Rob Wultsch <[EMAIL PROTECTED]> wrote: > > On Sat, Jul 19, 2008 at 6:54 AM, Jake Peavy <[EMAIL PROTECTED]> wrote: > > I may be wrong, but I think you could accomplish this through the use of > > triggers. Triggers are designed to monitor data change activity. > > > > -jp > > > Good tho

Re: Tracking changes in large datasets over time

2008-07-19 Thread Rob Wultsch
On Sat, Jul 19, 2008 at 6:54 AM, Jake Peavy <[EMAIL PROTECTED]> wrote: > I may be wrong, but I think you could accomplish this through the use of > triggers. Triggers are designed to monitor data change activity. > > -jp Good thought. Using triggers to keep track of changes in an intermediary tab

Re: Tracking changes in large datasets over time

2008-07-19 Thread Jake Peavy
On 7/18/08, Jason Yergeau <[EMAIL PROTECTED]> wrote: > > Hi Rob --- > > MySQL 5. > > > > On Fri, Jul 18, 2008 at 3:01 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > > On Fri, Jul 18, 2008 at 2:00 PM, Jason Yergeau <[EMAIL PROTECTED]> > wrote: > >> I'm having trouble working through a data problem. A

Re: Tracking changes in large datasets over time

2008-07-19 Thread Rob Wultsch
On Sat, Jul 19, 2008 at 4:18 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > On Fri, Jul 18, 2008 at 3:46 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: >> I'm sure there is a way to write this in a single query, but I bet it >> it is ugly as heck, probably with a bunch of derived tables. > > INSERT INTO

Re: Tracking changes in large datasets over time

2008-07-19 Thread Rob Wultsch
On Fri, Jul 18, 2008 at 3:46 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > I'm sure there is a way to write this in a single query, but I bet it > it is ugly as heck, probably with a bunch of derived tables. INSERT INTO balances (userid, points) SELECT users.userid, users.points FROM users LEFT JOI

Re: Tracking changes in large datasets over time

2008-07-18 Thread Rob Wultsch
On Fri, Jul 18, 2008 at 2:00 PM, Jason Yergeau <[EMAIL PROTECTED]> wrote: > I'm having trouble working through a data problem. Any tips or > keywords that might clue me into a known pattern would be incredibly > appreciated! > > I have about 500,000 users in my system. Each user has a points > ba

Re: Tracking changes in large datasets over time

2008-07-18 Thread Jason Yergeau
Hi Rob --- MySQL 5. On Fri, Jul 18, 2008 at 3:01 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote: > On Fri, Jul 18, 2008 at 2:00 PM, Jason Yergeau <[EMAIL PROTECTED]> wrote: >> I'm having trouble working through a data problem. Any tips or >> keywords that might clue me into a known pattern would be

Re: Tracking changes in large datasets over time

2008-07-18 Thread Rob Wultsch
On Fri, Jul 18, 2008 at 2:00 PM, Jason Yergeau <[EMAIL PROTECTED]> wrote: > I'm having trouble working through a data problem. Any tips or > keywords that might clue me into a known pattern would be incredibly > appreciated! > > I have about 500,000 users in my system. Each user has a points > ba

Tracking changes in large datasets over time

2008-07-18 Thread Jason Yergeau
I'm having trouble working through a data problem. Any tips or keywords that might clue me into a known pattern would be incredibly appreciated! I have about 500,000 users in my system. Each user has a points balance, updated by a system over which I have no control. I'd like to track changes t