If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Performance decrease with more report columns

Started by cognosun, 05 Jun 2012 01:09:32 AM

Previous topic - Next topic

cognosun

Hi,

Previously we have simple list reports in our module with 50 columns in each of them.

As per our latest requirements we added 50 more new columns to the existing reports ( we added them to same list report thus taking the total number of columns count to 100).

Now we are seeing decrease in performance....when I've talked with DBA...he said that increase in number of columns shouldn't impact the performance.

But I doubt this...as report size now obviously increases ( as 50 new columns pull more extra data ) againt the same unchanged environment ( or JVM Size)

Also with the increase in 50 more columns, more data comes and sits in temp folder..bringing report performance down ( not vast decrease but little decrease in performance).

Can anyone provide more inputs on this scenario ?

Grim

More columns = more data = more network traffic = longer to pull the data

Logical....no?
???
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)

dcsoke

Grim that was too logical. Whoever the DBA is doesn't understand the full scope of what is involved with reporting.

If the additional columns come from different tables then the joins will absolutely cause a delay. The extra data is also pulled and held in temp tables before being assembled into a presentation layer such as Excel or PDF.