Re: Database design

From: Mark Preston <mark_at_mpreston.demon.co.uk>
Date: Sat, 26 Aug 2000 12:06:43 GMT
Message-ID: <39a6c221.1565922_at_news.demon.co.uk>


No question about it - split the table but make sure the queries on the 'common fields' table are quick and have a good link to the 'other fields' table.

On Fri, 25 Aug 2000 03:46:25 GMT, "py" <py_at_ottawa.com> wrote:

>Hi,
>
>I have a question I have been debating for some time and I would like your
>thoughts on the subject.
>
>In one Internet application, I have a table with 22 fields. I access
>regurarly only 8 of those fields. Should I:
>
>- Make two table with a one on one relationship ?
>- Make one big table ?
>
>I am using MySql for the database on Linux, thanks.

-- 
Mark A Preston BSc, FIAP
The Magpie's Nest
mark_at_mpreston.demon.co.uk
Received on Sat Aug 26 2000 - 14:06:43 CEST

Original text of this message