topic Re: demerit of cursor (tOracleInput) in Talend Studio

demerit of cursor (tOracleInput)

Anonymous — Thu, 18 Apr 2019 11:26:48 GMT

In the advanced settings of the input components, there is a use cursor / cursor size option.I suppose this option works good when the size of input DB is big.

But by default , this option is off.

Q1: Is there any demerit if cursor option is on ?

Q2: In other case ,I mean when the size of input DB is small, should this option be on ?

I'm using talend open studio for data integration.

Re: demerit of cursor (tOracleInput)

Anonymous — Mon, 22 Apr 2019 10:01:54 GMT

Hello,

It is based on an Oracle functionality (fetch array size in the JDBC driver)

The performance can be improved by tuning this fetch size to an appropriate value.

Let us know if it helps.

Best regards

Sabrina

Re: demerit of cursor (tOracleInput)

Anonymous — Mon, 22 Apr 2019 10:15:55 GMT

@coffeeno

When you are increasing the number, please do not put an exorbitantly high value as that also will create issues. There are no magic numbers in this case. Start with 10,000 records and see the results of DB. The number depends on the system resources and various other DB parameters. So you will have to do trial and error using performance testing to arrive at the right results.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: demerit of cursor (tOracleInput)

Anonymous — Wed, 01 May 2019 02:04:59 GMT

I woul like to know about
Q1.

Re: demerit of cursor (tOracleInput)

Anonymous — Tue, 07 May 2019 10:45:13 GMT

I woul like to know about
Q1 above.

Best regards,

Re: demerit of cursor (tOracleInput)

manodwhb — Tue, 07 May 2019 10:54:07 GMT

@coffeeno ,you can enable cursor in tOracleInput,please check the below screen.

Re: demerit of cursor (tOracleInput)

Anonymous — Tue, 07 May 2019 11:11:11 GMT

I woul like to know about
Q1: Is there any demerit if cursor option is on ?

Re: demerit of cursor (tOracleInput)

Anonymous — Sat, 11 May 2019 02:27:48 GMT

I woul like to know about
Q1: Is there any demerit if cursor option is on ?

Q1-2: Are,order and sequence and so on when using cursor are same as when not using cursor ?

Re: demerit of cursor (tOracleInput)

Anonymous — Wed, 15 May 2019 20:22:30 GMT

Hi,

The best way to check it is by measuring the database statistics and ETL statistics with by tryng both options. I have not tried them personally. But I would recommend to try with 100,000 records minimum to get a visible difference.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂