Re: SQR/REPORT BUILDER

[Scott Eubank <SEUBANK@ADVANCEAUTOPARTS.COM>]

I mean no experience with HTML FILES ...

-----Original Message-----
From: Scott Eubank [mailto:SEUBANK@ADVANCEAUTOPARTS.COM]
Sent: Tuesday, April 10, 2001 9:31 AM
To: SQR-USERS@list.iex.net
Subject: Re: SQR/REPORT BUILDER


JOHN,

  I dont have any experience with spf files and sqr , SO I wont be of any
help here. But I sure someone will be able to help you out.  But I would
gander that the added hardware would definately help.

-----Original Message-----
From: John Roddy [mailto:jroddy@BROMLEYGROUP.IE]
Sent: Tuesday, April 10, 2001 9:12 AM
To: SQR-USERS@list.iex.net
Subject: Re: SQR/REPORT BUILDER


Scott,

I am not printing this file, I am creating a HTML File, but report builder
generates a spf file of over 1gig and the HTML file was 1.8 gig before it
crashed. I have about 14 variables in the query from 4 d/b tables. I know
that this type of query seems excessive but I may even need to build larger
queries. Would more memory solve my problem. I estimated that I would need
1gig and 30 gb hard disk space would this be sufficient??

What we would do would be zip the htm file and send it up to the web server.

John

> -----Original Message-----
> From: Scott Eubank [SMTP:SEUBANK@ADVANCEAUTOPARTS.COM]
> Sent: Tuesday, April 10, 2001 2:10 PM
> To:   SQR-USERS@LIST.IEX.NET
> Subject:      Re: SQR/REPORT BUILDER
>
> 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.