Focal Point
[CLOSED] Data Retrieval

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2857021695

December 30, 2010, 10:31 AM
OITTester
[CLOSED] Data Retrieval
I am new to WebFocus, I need some guidance on a few things, when I run a report, it takes too long to respond or return data from the database. I have added parameters to the report but still the same issue. How can I resolve this issue? Any suggestions or help will be greatly appreciated.

Thanks,

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6
HP AIX (SERVER) & XP (Local)
all output
December 30, 2010, 10:45 AM
<JG>
? database
? No of rows in the source
? is it a joined source
? is there any filtering on indexed columns
? is there any filtering on non indexed columns
? No of rows being returned
? format of returned output

We're not mind readers
December 30, 2010, 12:42 PM
OITTester
JG,

Yes, you are not a mind reader; I have found a solution, using a HOLD file.

I hope you have a good day.


WebFOCUS 7.6
HP AIX (SERVER) & XP (Local)
all output
December 30, 2010, 03:44 PM
Waz
For other new starters, could you post a better explanation. It may help them.


Also edit your original post and add [SOLVED] to the title, so we all know its fixed.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!