How many maximum number of fields can be there in a table?

[Former Member]

How many maximum number of fields can be there in a table?

[aashish_sinha]

Hi,

I don't know what the exact limits are, but my guess is that speed will decrease quite badly, because of the amount of data transferred between the server and client. Plus, having a ton of fields most likely screws up caching, so that will also slow things down.

That said, you should NEVER have more than say 100 fields, and even that is generally too much. You will also never need more than 100 fields. If you think you do, your data is either not fit to be stored in a database, or you aren't exploiting database features (like JOINs, subqueries, etc.) enough.

Regards

Aashish Sinha

PS ; reward points if helpful

[Former Member]

Unlimited.

But as the no. of fields increases the performance become lower

[Former Member]

Hi,

No Limit

But max 16 key fields should be there.

But you have more than 250 fields then performance might be problem.

Thanks

Vikranth

Edited by: Khimavath Vikranth on Jun 26, 2008 11:19 AM