Skip to Content
Former Member
Sep 09, 2009 at 05:06 AM

performace of query


HI All,

I am working on BO XIR3.1. i want to know about the query performance between 2 scenario -

1) i have 4 dim obj with aggregate object in single query so all 4 object come under group by i have created 4 table in report with individual object & aggregate table and need to show group by with dim object into each table.

2) i am creating 4 dataprovider with individual dim object and agg. obj.

When data will grow can be million records as per performace wise which scenario will work fast.