On Thu, 6 Sep 2007 14:37:02 -0400, "shank" <shank@t...>
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

You haven't really explained your scenario or your data at all.

5000 records is a very small recordset indeed, but that depends on the
size of each set of nodes of course - if you're storing base64 image
data of PSD or TIFF files then it will be large (and XML will not be
what you need here).

What do you mean download - to a browser ? GZip the output. XML
compresses very well indeed because all those repeated <tagname />
elements tokenise to one or two bytes in the GZipped output (as does
most text data)

Cheers- Neil
------------------------------------------------
Digital Media MVP : 2004-2007
http://mvp.support.microsoft.com/mvpfaqs