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.
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
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.