General error: 1116 Too many tables; MySQL can only use 61 tables in a join

[FTTech]

Hi,

We have around 250 fields in opportunity table (I understand its quite a lot and I am unable to distribute to another table due to multiple areas of selling), When I add few more fields I am getting the error as mentioned in the subject.

Could someone throw some light on this that if there is any limit on the fields in opportunity table after which the joins are too many with other tables ? I am not using any custom joins etc , whatever came with basic install.

Thanks
AH

[Maximus]

Hi,
Well, this issue is related to a DB limitation. There are 2 thoughts:
1. You can try to find a way of how to change the limitation value.
2. Create a new Entity for storing the most part of the fields (e.g. let's say your original entity called 'Account', so you need to create a new one like 'Account Data'). Then relate them with one-to-one relationship to in order to be able to fetch data.

[FTTech]

Thanks,

I will work on that solution.