[resolved] Cpu Utilization in TOS DI

[Anonymous]

hi all,
i'm using TOS DI 5.2.2 in linux red hat. In my jobs i'm using following components:
tFileInpuDelimited, tMap, tFileOutputDelimited, tVerticaRow, tMysqlSP, tMysqlOutput, tSortRow, tUniqueRow, tFileExist, tFileList, tFileDelete, tVerticaInput, tVerticaOutput, tMysqlInput, tVerticaConnection, tMysqlConnection.
I have some questions about cpu utilization:
1) What are the major components which will effect our cpu utilization?
2) How to use those components in order to prevent high cpu utilization?

It will be very helpful if u suggest some tips.
Regards,
Akki

[Anonymous]

Hi,
There are some cache components consuming studio memory. Such as tMap, tUniqRow, tSortRow. For a large set of data, try to store the data on disk instead of memory.
TalendHelpCenter: OutOfMemory.
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
Sorry for delay reply. and thanx for your quick reply.
If i give in tMap "store data in disk" whether,
i) data will be stored parmanently??
ii) only during job execution data will be stored??
iii) for only processing it use disk memory??
Regards,
Akki

[Anonymous · Accepted solution]

Hi,
If you select the option "Store on disk", the lookup data will be stored on a defined path.(D:/file), which will not consume studio memory, disk instead to avoid the outOfMemory Java exception.
Best regards
Sabrina

[Anonymous]

hi sabrina,
Thank you for help. i will mark this topic as resolved.

Regards,
Akki