ODBC Connection Performance Degradation in PA Server 2.0.9.14 and later

Post Reply
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

ODBC Connection Performance Degradation in PA Server 2.0.9.14 and later

Post by mce »

Hello,

After upgrade to PA 2.0.9.14, we have seen major performance degradation in TI processes pulling data from Oracle DB to TM1.
Is there anyone else who have seen this problem and any solutions so far?

All responses will be appreciated.

Regards,
User avatar
Steve Rowe
Site Admin
Posts: 2424
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: ODBC Connection Performance Degradation in PA Server 2.0.9.14 and later

Post by Steve Rowe »

Hi mce,
There has been a change in the handling of ODBC in recent releases, however we were getting out and out failures not performance drop off.

There is a long thread by Herman on the IBM forum that details something in this space, where some specific type of rule references are hitting performance of load routines.

https://community.ibm.com/community/use ... ata-slowly?
Technical Director
www.infocat.co.uk
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: ODBC Connection Performance Degradation in PA Server 2.0.9.14 and later

Post by mce »

When we execute a TI process loading data from Oracle DB, it takes twice longer in new version compared to old one.
With the new version, as we run the same process in multiple concurrent threads with different parameters to load different slices of the data, then data load speed for each thread decreases. As the number of concurrent threads increase, number of records loaded per second in each thread decreases. It looks there might be some sort of bottleneck with the new ODBCProxy which limits the total records retrieval speed in TM1 Server.

mce wrote: Mon Feb 27, 2023 12:30 pm Hello,

After upgrade to PA 2.0.9.14, we have seen major performance degradation in TI processes pulling data from Oracle DB to TM1.
Is there anyone else who have seen this problem and any solutions so far?

All responses will be appreciated.

Regards,
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: ODBC Connection Performance Degradation in PA Server 2.0.9.14 and later

Post by mce »

APAR is created for this issue:
PH53021: ORACLE ODBC DATASOURCE PERFORMANCE SLOWER THAN PREVIOUS VERSIONSOF PA
https://www.ibm.com/support/pages/apar/ ... s=swgother
Post Reply