Re: SQR/REPORT BUILDER

[John Roddy <jroddy@BROMLEYGROUP.IE>]

Thanks 4 that Scott, I think the added h/w will be needed alright.

Thanks again.

John
PS anyone else with any ideas?

> -----Original Message-----
> From: Scott Eubank [SMTP:SEUBANK@ADVANCEAUTOPARTS.COM]
> Sent: Tuesday, April 10, 2001 2:31 PM
> 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.