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
