Currently you can update your database through:
1. Flex2SQL
2. dbBuilder
3. DataFlex restructure commands
4. Directly on the SQL Server and manually changing INT files
It is common to have a DBA that wants to review all schema changes to the database, which makes options 1-3 difficult, or outright prohibited by the DBA. Option 4 is manual and prone to errors.
The Mertech Drivers allow to improve performance when inserting records by using the SQL_SAVE_BUFFER macro command. You can specify a block of records, that will be submitted in batch to the server, instead of having each record be saved at a time.
You can set the block size based on the DF_FILE_RECORDS_USED attribute from the source table or knowing the number of records that will be inserted and, for example, multiplying the number by 0.10 to get save batches of 10% of the table size.