Re: SQR/REPORT BUILDER

[Scott Eubank <SEUBANK@ADVANCEAUTOPARTS.COM>]

BETTER GET MORE MEMORY.  We have 600gigs of HD and 6gb of memory on our
boxes. heheheheheee.

  What exactly are you doing?  There is no way your PRINTING 2.65 million
rows to paper cause you post would have read "MY SQR IS RUNNING OUT OF
PAPER", so are you spinning these off to a flat file to process some other
way.  Are you accumulating an ARRAY?  How many variables do you have?

SQR keeps all global variables and arrays resident in memory and local
variables are static. SO you could easily eat up .5gb of memory in a heart
beat with 2.5 million rows if your sqr is written incorrectly.


Scott

(who's still trying to figure out how to fill up 6gb of memeory :)


-----Original Message-----
From: John Roddy [mailto:jroddy@BROMLEYGROUP.IE]
Sent: Tuesday, April 10, 2001 4:52 AM
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.