Hi Guys,
Maybe someone can explain how exactly engine works for LOV in those two different systems.
I have 100000 instances in table.
At Crystal i defined LOV for those instance (for example call them interface). Therefore when i`m running report with this LOV it takes about 4-5 minutes to open prompt report.
At webi reports, i defined LOV for some interface from same table. When i`m running report it takes about 2-3 seconds to bring me list of all 100000 instance.(also refresh of list takes couple of seconds)
Could anybody exmplain me how it`s works and why there is such big difference between crystal and webi reports?
Maybe someone can explain how exactly engine works for LOV in those two different systems.
I have 100000 instances in table.
At Crystal i defined LOV for those instance (for example call them interface). Therefore when i`m running report with this LOV it takes about 4-5 minutes to open prompt report.
At webi reports, i defined LOV for some interface from same table. When i`m running report it takes about 2-3 seconds to bring me list of all 100000 instance.(also refresh of list takes couple of seconds)
Could anybody exmplain me how it`s works and why there is such big difference between crystal and webi reports?