Re: SQR/REPORT BUILDER

[Brian Smith <BSmith@TEMPO.CO.UK>]

Sorry John, but this seems a hugely a misguided exercise, and more hardware
is unlikely to solve your problem.
What on earth is the use of a 1.8GB HTML file - who could read it? The SQL
language was invented to query large amounts of data without needing to ship
them around the network. I suggest you leave your data in Oracle.
Alternatively, investigate some Data Warehouse technologies - Microsoft SQL
Server would be a good start.

Brian Smith

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



***IMPORTANT***
The information in this mail is confidential and is intended solely for the
addressee. Access, copying or re-use of information in it by anyone else is
unauthorised. Any views or opinions presented are solely those of the author
and do not necessarily represent those of Tempo Ltd or any of its
affiliates.