"Martin Honnen" <mahotrash@y...> wrote in message 
news:O2xMq9H9HHA.5980@T......
> shank wrote:
>> I have a huge amount of data that needs to be exported into XML. Over 
>> 5000 records plus some 25 fields including a couple fields with TEXT 
>> attributes. It's just a stinkin' bunch of data.
>>
>> Problem: Whenever I populate a database field (out on the server) with 
>> the entire feed, with the intent to download or write to a file, I can't 
>> download because there's not enough memory available and timeouts.
>>
>> How do the pros handle these huge amounts of data?
>
> MS SQL Server 2000 and 2005 have a FOR XML clause for the SELECT statement 
> which generates XML and streams the XML to the client, that might help: 
> <URL:http://msdn2.microsoft.com/en-us/library/ms191268.aspx>
>
>
> -- 
>
> Martin Honnen --- MVP XML
> http://JavaScript.FAQTs.com/
= = = = = = = = = = = = = = =  =

I'm using that statement to generate the XML code. I'm trying to generate 
that code then pass to our users out of convenience for them. However, the 
size of the generated code is HUGE and I'm having problems making it a 
convenient download. Once I get it into a database field, it's so large that 
browsers timeout trying to access it.
thanks