"just curious, which application produce such huge files? I have seen few log files as large as this."
it's an app for converting XML-files from the Swedish tax aurthur with tax-data (and som other stuff, like EU custom-data). I'm doing this for a company witch business is to hold a databas with this data and distribute it to there customers directly from databas to database so they wount have to create this app for there self. My app, downloads, pgp-validates, unzips and convert the XML to SQL and then loads them in to a database. They distribute a number difference-xml-files every night and a number of total-xml-files every month or so. It's these Totals that is so big. I only need to run them the first time a start the applikation and if theres a crach and no way to get restor the data from backups. But I still need to run them. Micke Jansson On Sat, Nov 22, 2008 at 04:40, Mukul Gandhi <[EMAIL PROTECTED]> wrote: > On Fri, Nov 21, 2008 at 2:01 AM, Mikael Jansson <[EMAIL PROTECTED]> > wrote: > > Is there any way I can resolve this? I need to transform XML-fils up to > 4GB. > > just curious, which application produce such huge files? I have seen > few log files as large as this. > > I think if you need to store huge amount of business data, you can opt > for a relational/XML hybrid database (like DB2 with pureXML) [1]. > > With [1], you can store data in XML form (along side relational data) > which makes good business sense. You can keep rest of data in > row-column relational form. > > > -- > Regards, > Mukul Gandhi >