You can configure the limit when if a big clob and or blob data is stored in a temporary files file with the additional connection property **lobBuffer***lobBuffer* which is set to "32768" (32kb) by default. Means by default every clob or blob data which is bigger than 32kb is stored as an temorary file. Our recommendation is to increase *lobBuffer* to 524288 (512kb) or even more, but not too big if you have not enough memory. Fore a good value which suits your needs you can look at the file size of the jdtsXYZ.tmp files already created.
For other performance improvements you could also increase the follwoing properties:
- *bufferMaxMemory*
