May be I am worrying but is 55 fields too much

[ade234uk]

May be I am worrying but is 55 fields too much for a table in mysql if I had 6,000 records stored?

[Drakla]

Can't really say without more information. If you're not storing redundant data in the fields then there's no problem.

[ade234uk]

It will be used to hold rental rates for holiday homes.

[Drakla]

So each holiday home has 54 possible rates...? Think it might be time to show us the schema of your table(s).

[MarkR]

Provided it's all normalised reasonably, and you can justify the existence of all the column in that table, no, 55 fields is not too many.

If they are (e.g.) rate_1, rate_2, rate_3, then this is a design error and should really be fixed by adding a separate rate table.

Mark