I have a project I'm working on for a Richmond-based home inspector. I'm trying to insert the reports into a table. Problem is, if I put the reports into one table, the table is going to have about 500 fields. I'm concerned that such a large number of fields would have a detrimental effect on the performance of the MySQL.
So, is 500 fields too many fields to put in a table?
Are we talking about a database or a spreadsheet?
If you truly need 500 fields for an entry, then I guess you don't have a choice. But really it comes down to proper organization, if it can be delegated between often used, not often used, or almost never used, you could slim down some of the items.
I don't think it would have a hit on performance of mysql, but it certainly will be hell to maintain.
All of the fields will be used when someone wants to view the report.
Quote:I don't think it would have a hit on performance of mysql, but it certainly will be hell to maintain.
I knew from the start that it was going to be a big project, but that does encourage me somewhat.
Like you don't have enough to do...
With 7 classes right now, a huge presentation to give by myself in front of about 100 people, and this project, I think I'll keep myself busy somehow.
Thanks for the input.
Well I'm sure that you won't be on chat.