Table Design -- which is better?

2001-02-23 Thread Nino Skilj
I have a general design question. Is it better to design one table with 45 columns or to split it into 3 tables with 15 columns each. There would be about 5000 rows in the table and it would be used more for reading rather than writing. I'm new to this, is there anything I'm missing? Thanks,

Re: Table Design -- which is better?

2001-02-23 Thread Tbone
Hi, How would the data look a like. And how about the query's Greetz Tbone - Original Message - From: "Nino Skilj" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 24, 2001 12:17 AM Subject: Table Design -- which is better? I have a general desig

RE: Table Design -- which is better?

2001-02-23 Thread Nino Skilj
The data would be 1's and 0's (on/off) Nino -Original Message- From: Tbone [mailto:[EMAIL PROTECTED]] Sent: Friday, February 23, 2001 4:18 PM To: [EMAIL PROTECTED] Subject: Re: Table Design -- which is better? Hi, How would the data look a like. And how about the query's Greetz Tbone