BusinessObjects Board

How can we tune the free hand sql DeskI report

building reports desktopintelligence
#1

Hi Folks,
I have developed a DeskI report by using free hand sql .
When ever refresh the report,it will takes time 5 to 8 hours.
How can I tune the report.Wt is the reason?

Thanks in advance.
Regards,

Athadu

Kamalini :india: (BOB member since 2007-10-11)

#2

Edit the FSQL connection and increase the array fetch size …
hope this will help…

raveesh (BOB member since 2007-11-24)

#3

Please, take a look at the Reporter FAQ section “Why is my report so slow”.

Andreas :de: (BOB member since 2002-06-20)

#4

We cannot help you tune the query unless you give us at least it’s structure.
The basic thing I can say is create some indexes on the tables beneath.
You didn’t specify the DB engine so I can be more specific.

AldoWeb :albania: (BOB member since 2005-05-24)

#5

Hi

The following tips may help you in query performance.

Use the Index columns on the query
Avoid full table scanning
Order the query by Low weightage to High weightage
Avoid case statement and sub-queries.

Regards

Siva.M

looksmee :uk: (BOB member since 2006-02-08)

#6

Thanks for your kind help

Regards,
:smiley:
Athadu

Kamalini :india: (BOB member since 2007-10-11)