Speed up the Update or Insert to DBOutput

[thomas_2583]

Hi

Is there anyway to speed up the Update or Insert from a TDBInput ---> TMap --->TDBOuput please?

[Anonymous · Accepted solution]

Hello,

What's your current rows/s and what's your source and target DB?

As tMap is a buffer component and you can change the basic configuration to store temporary data on disk rather than in memory. For example, on tMap, click the tMap settings panel of Lookup flow and select the Store temp data option as true.

Best regards

Sabrina