Query How do we resolve “Out of Memory†error while importing vouchers from Excel to Tally? Solution In comparison to Import of Data through XML/SDF Files, Updation of data through User Defined Functions takes a much longer time. A performance lag has been observed while updating data with User Defined Functions, as compared to updating data of a similar size by the Import method. Importing of Data implicitly follows a Batch Posting approach, wherein the data to be incorporated in the database is updated in batches, thereby improving the performance. This approach has been extended to data updation through User Defined Functions from Tally.ERP9 Series A Release 4.8 onwards, with the introduction of two new Actions, namely START BATCH POST and END BATCH POST. Batch Posting Mode accumulates sets of Objects into batches, and pushes a whole batch of data into the database at a time, which optimizes the performance. The usage of these actions is documented comprehensively in TDL Reference Manual in the topic Batch Posting Actions - START BATCH POST and END BATCH POST.
