|
|
Posted by Andy Jeffries on 11/02/05 17:15
cover wrote:
> For lack of a better input method, I'm thinking of a form with many
> input fields (i.e. 25) for users to enter equipment related
> information. As I think about connecting and entering into a MySQL
> database, 25 fields or so on one table seems like a lot so I am
> thinking about breaking it up into categories. For example the
> database name=equipment and tables for pumps, conveyors, shakers, and
> 'other'. Any thoughts on this folks? I could do the table name as
> equipment_tbl for example with its 25 fields but am a little concerned
> with how the physical size of this database *might* grow. Feedback is
> appreciated. TIA
Personally, I wouldn't worry about 25 fields, it's not a lot. But bear
in mind future growth (maybe individual tables might be better) against
ease of extraction (multi-table joins for lots of tables).
Cheers,
Andy
Navigation:
[Reply to this message]
|