Business Object 5.0

general discussion
1

We just installed Business Objects 5.0 and noticed that it runs queries much slower than 4.1.
Anyone else have this problem? If so is there a fix? Thanks

Shirley Knight shkk@ti.com 972-927-6340
Business Objects Support at Texas Instruments Inc.

Listserv Archives (BOB member since 2002-06-25)

2

What version did you install? sp2 is out and available.

What environment are you running BO in DB?, Middleware?

Sincerely,

Tom Nather
Data Warehouse Group
Penske Logistics
email:tom.nather@penske.com
Phone: 216-765-5787
Fax: 216-765-5666

Listserv Archives (BOB member since 2002-06-25)

3

Shirley,
can you try this - Increase the array fetch size to 100, you can do it by , In designer, File - Parameters - Definitions - Edit - Advanced. BO 5.0 has a very low value of array fetch size as default. thanks,
Saket

shirley wrote :

We just installed Business Objects 5.0 and noticed that it runs queries much slower than 4.1.
Anyone else have this problem? If so is there a fix? Thanks

Listserv Archives (BOB member since 2002-06-25)

4

Saket,
What would a reasonable array size be?

Thanks.

Kathy Vazquez

Listserv Archives (BOB member since 2002-06-25)

5

Kathy,
Large values of Array fetch size affect your memory on the client. 100 is quite reasonable if your query normally returns rows in the order of 1000’s , however keep in mind if your query is returning a long text or blob then the value of array fetch size is automatically reset to 1.

thanks,
Saket

kathy wrote :

What would a reasonable array size be?

Thanks.

Kathy Vazquez

Listserv Archives (BOB member since 2002-06-25)