Re: [GENERAL] table design and data type choice

2014-01-08 Thread Sameer Kumar
On Wed, Jan 8, 2014 at 3:11 PM, Jayadevan M wrote: > We have a table to record the voteup/votedown by users of questions and > answers (like on stackoverflow). So there will be a large number of inserts > (voteup/down), some updates(user changes mind)and may be a few deletes. The > queries will be

[GENERAL] table design and data type choice

2014-01-07 Thread Jayadevan M
Hi, We have a table to record the voteup/votedown by users of questions and answers (like on stackoverflow). So there will be a large number of inserts (voteup/down), some updates(user changes mind)and may be a few deletes. The queries will be mostly aggregates (count(*) where question_id= and vo