Focal Point
[SOLVED] What is the mechanism behind MAINTAIN's MODIFY/MATCH/NOMATCH on SQL database

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3517042876

September 04, 2015, 12:17 PM
bug
[SOLVED] What is the mechanism behind MAINTAIN's MODIFY/MATCH/NOMATCH on SQL database
Is it INSERT/UPDATE query or batch load? Is there a way to improve the performance, like setting the number of rows in each batch?

Thanks!

This message has been edited. Last edited by: <Kathryn Henning>,


7.66 and 7.704
System: Windows / AIX / Linux
Output: Mostly HTML, with some PDF, Excel and Lotus(!)
September 04, 2015, 01:27 PM
Maintain Wizard
With Maintain, the inserts are still record at a time. We HAVE seen improved performance if the data is sorted by keys before the Include.

Mark