Buffer size issue while adding new fields in Sales Table

Hi Guys,

I am having buffer size issue while adding more fields in SalesTable. Does anyone have any workaround to overcome this issue other than increasing the buffer size from server configuration which could lead to performance impact?

I thought to create a parallel table with SalesTable which could be used in future customization (adding more fields) and would associate this table on SalesTable form using SalesId relation on this new table with SalesTable. It works but only when I create new records in salesTable due to the relation defined between SalesTable and newly created table. However, it is not working with existing sales orders as there is not associated SalesId (from sales table) in newly created table.

If I will go with this approach I have to run a job to update all SalesId from SalesTable to newly created table for existing records.

Does anyone has any workaround rather than adding a new table or have ever come across with such requirement?

Kindly do share your experience.

Regards,
Faisal Fareed

Hi Faisal,

once go through this link it will help you

http://axwonders.blogspot.in/2011/01/internal-size-of-records-in-your-joined.html

Regards,

Phani.

Hi Phani, Thanks for your response but I am not intended to increase buffer size at all. This is why I thought to create another table.