The job has 2 odbc stages and in one of the odbc stage I used a query which has just 2 conditions using where.
The issue is the job takes 70 minutes to run. Is there any way to increase the performance.I see in the monitor of that job, seems the odbc with the query takes long time.
running a job
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 30
- Joined: Thu Jan 14, 2010 5:46 am
- Location: Austria
Hi,
it's really hard to give you an advice without knowing any details
e.g.
- the job requirements (number of records to be processed, selectivity of the where clause, ...)
- the design (downstream stages, job logic, ...)
- configuration of your system (degree of parallelism, environment, setup, used dbms...)
according to your statement that you are using a where clause in one of your odbc stages my first guess is that there is an index missing and your dbms has to perform expensive table-scans.
BR
Werner
it's really hard to give you an advice without knowing any details
e.g.
- the job requirements (number of records to be processed, selectivity of the where clause, ...)
- the design (downstream stages, job logic, ...)
- configuration of your system (degree of parallelism, environment, setup, used dbms...)
according to your statement that you are using a where clause in one of your odbc stages my first guess is that there is an index missing and your dbms has to perform expensive table-scans.
BR
Werner
-
- Participant
- Posts: 248
- Joined: Fri Jul 30, 2010 9:04 am
sorry for the incomplete information
The ODBC stage is used and the DB is informix
the records are around 700000
A query is used to get data from 2 tables and with where condition
for two conditions.
like the query is
select a.name,a.phone,a.fax,b.state from person_info a,address b where a.pid=b.pid and b.status="C";
The ODBC stage is used and the DB is informix
the records are around 700000
A query is used to get data from 2 tables and with where condition
for two conditions.
like the query is
select a.name,a.phone,a.fax,b.state from person_info a,address b where a.pid=b.pid and b.status="C";
Regards,
Kenny
Kenny
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: