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 ?
More columns = more data = more network traffic = longer to pull the data
Logical....no?
???
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.