I can't think of any reason to have that many fields. It really starts
to make the databases structure unmanageable, or at least difficult and
time consuming to manage. It also can make it very difficult to create a
good, flexible search interface.
Filemaker might be an exception because of the way it's relations work
and the limited options you have for displaying related information.
Searching on related fields in FileMaker also gives you a very generous
performance hit. :)
I usually try to design my databaes vertically instead of
horizontally. For instance, each phone number for someone would be a
record in another table, rather than having separate field for home,
work, cell, fax, etc. This gives you much more flexibility, like
tracking 3 home phones, 2 cell phone, 2 faxes, and a work phone.
On Tuesday, September 3, 2002, at 10:00 AM, Brian Leyland wrote:
What is the limit on amount of fields in a MYSQL table.
Access / lotus will only do 255, whereas Filemaker will do over
Hopefully someone will tell me it is more than 459 (that is what I need
in
mine).
Thanks
Brian Leyland
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php