On Tue, 28 Mar 2006, Brian Erickson wrote:
> To: mysql@stripped
> From: Brian Erickson <erickson.brian@stripped>
> Subject: Customer Recommendation Query
> We are using MySQL version 3.23. There are approximately
> 500 unique rows in the 'actions' table and 2,000,000 rows
> in the member_actions table, with 3,000+ actions being
> recorded at any given time.
> So, our question is whether or not this is feasible with a
> one/few query approach, or if this is something that
> should be accomplished with something similar to the
> approach above? Can anyone provide a good start for us?
I think a good start would be to consider the possiblity of
upgrading from 3.23 to 5.0.18/19.
I'm sure there is alot more functionality available for you
to utilise then - not just in SELECT statements either.
In theory, theory and practice are the same;
in practice they are not.