Our datasource of COPA contains approx 200 fields. We have created a single write optimized DSO to get all those 200 fields.
Considering the effects on Database or performance of report , what is the best practice?
a) create a single standard DSO and get all 200 fields with data into it and write a report on top of it?
b) partition the fields and data into multiple write optimized DSO or Standard DSO?