Re: SQR/REPORT BUILDER

[Tim Wilkinson <Tim.Wilkinson@HANCORP.CO.UK>]

You could try using the -Tnn parameter when running the report to make sure
that it is working at least. SQR has a nasty trick of ignoring any invalid
Where clauses and instead of telling you that you have an error it happily
creates a cartesian, which will take forever.

Also the -S parameter will tell you how many rows the report will bring back
and will show any cursors etc. Looking at this you can get an idea of how
long it might take and how you can get things tuned.

Finally, include a counter in you SQL and o/p this using SHOW. This will
tell you how many rows you have pulled back before it dies.

Hope this helps.

Tim

(Is there no way you can restrict the data further? 2.65 million rows of
information are not going to be too usefull if you are outputting them I
wouldnt have thought)

-----Original Message-----
From: John Roddy [mailto:jroddy@BROMLEYGROUP.IE]
Sent: 10 April 2001 09:52
To: SQR-USERS@list.iex.net
Subject: SQR/REPORT BUILDER


Hi All,

I am new to the above products an was hoping somone could advise me on the
following please.

I have installed the above products, and want to create a report that will
pull back 2.65 million rows from an Oracle 8i DB. The server that I have
tried to run this type of report on has a dual processor, 2.75 GB of hard
disk space and .5 GB of RAM. The report crashes as the machine runs out of
memory. Has anybody had experience building such a large report using report
builder, and what time frames could I expect to complete such a report in,
(at the moment the report runs for over 4 hours before crashing) and also
what hardware architecture would you recommend (RAM AND Hard disk space).

Thank you

John Roddy.