sql server reporting services: Will Microsoft Reporting Services struggle with large data volumes? -- sql server reporting services

Re: Will Microsoft Reporting Services struggle with large data volumes?

Chris McGuigan
7/5/2005 7:40:42 AM

sql server reporting services:

Mark,
RS is not a good tool for creating very large datasets. It can do it,
and 100,000 would probably be OK - but not to excel! But it wouldn't be
recommended.

If you've got RS, you've obviously got SQL Server so I'd suggest using
DTS (Data Transformation Services) which is designed for exactly this
sort of thing.

There is another forum for DTS.

RS can handle lots of data no problem, but the format you're rendering
to is really the limiting factor. Excel can only have 65000 or so rows.

Chris

[quoted text, click to view]

Re: Will Microsoft Reporting Services struggle with large data volumes?

Bruce L-C [MVP]
7/5/2005 9:01:46 AM

If you try to do large amount of data to PDF or Excel you will definitely
have problems. CSV does much better. I have done 65,000 rows into Excel no
problem (CSV, ASCII format. Note that default is Unicode and you have to
explicitly specify on the URL to use ASCII instead of unicode). As a test I
just did 200,000 rows and brought it into Minitab. My data is small (only a
couple of rows) but 200K in CSV ASCII format took about 1/2 minute to
export. Took minutes to bring into Minitab but the file was saved to disk
very fast. The number of pages as HTML was about 2,000 pages. So, you might
be OK, the best thing to do is a test but I would say from my quick test
here that when dealing with CSV it might work for you. Note, this is NOT
true for PDF or Excel format.

HTH,

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Will Microsoft Reporting Services struggle with large data volumes?

MCC
7/5/2005 12:54:33 PM

Hi

Is Microsoft Reporting Services a good tool to use for the generation of
datasets to be exported to external systems (as CSV or the like) or does it
start struggling with large data volumes?

We will have data feeds, which will soon have 100,000's of records. Is this
type of thing fine for Reporting Services or are there limitations, from
which point a dedicated integration tool should be used?

Thanks

Mark

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.