Re: [PHP] Best way to store Votes for Survey app

2002-10-27 Thread Andrew Brampton
Say item_id was a int(10) member_id was a int(10) date was a timestamp(14) rating was a int(1) then each record would take up 35bytes + a little overhead Neglecting the overhead 20,000 records would take up only 700kb of space. So size of the db shouldn't be a issue. But if it is then you could c

RE: [PHP] Best way to store Votes for Survey app

2002-10-27 Thread John W. Holmes
That's the method I would use. You could try having a separate table for each poll, though. ---John Holmes... > -Original Message- > From: Monty [mailto:monty3@;hotmail.com] > Sent: Sunday, October 27, 2002 3:21 PM > To: [EMAIL PROTECTED] > Subject: [PHP] Best way to store Votes for Surve