InfoView - long time of report refreshing

[Former Member]

Hello all,

I have some troubles with report refreshing time.

I would like to execute query (result: 96columns, 440 000 rows) in InfoView.

I have checked this query and execution time is less than 30 seconds but waiting time for result is very long. Data transfer: 120 rows/second.

Do you know any tricks to optimize report refreshing time in BO?

Thanks in advance.

[Henry_Banks]

Hi,

first, some basics :

• what's your version, support package, and patch level ?

• what's your datasource vendor, version, and middleware? 

• Unv or UNX, or direct connection?

Please note that 42 Million cells is a very large resultset, and can't be recommended. that's like a data-dump, for which you should use an ETL tool.

Regards,

H