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.