IMNSHO, never store dynamic data in a field unless you absolutely have to. There are going to be exceptions, but unless a manager is going to participate in hundreds of thousands of fixtures I don't think this is one of them.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com >-----Original Message----- >From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] >Sent: Wednesday, September 01, 2010 4:29 PM >To: [MySQL] >Subject: Best method to keep totals > >Hi, > >I'm developing a system whereby a manager gets assigned points based a >certain number of factors which are saved alongside a football result. > However, I also want to keep a total for each manager. My question is it >best to just have a query that uses SUM to total the managers points gained >for each fixture participated in ? Or should I be looking to have >a separate field which is the calculated total for each manager ? > >Thanks in advance for any advice. > >Cheers >Neil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
