Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
IceDread
Yak Posting Veteran
66 Posts |
 Posted - 2007-11-22 : 05:09:10
|
| Greetings!I sometimes findmyself in need to open and check some variables in xml files that can be on several mb in size. When they are that large there is no tool that I know about that can handle it, it simply sucks up all my ram memory and well, it fails. So I am wondering if there is someone out there that has found a solution for this, is there some nice free tool out there?Notepad wont cut it since I want the xml to be clear and not compressed on several long rows.Thanks! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
IceDread
Yak Posting Veteran
66 Posts |
Posted - 2007-11-22 : 07:05:37
|
| Thanks, but I closed it down when it reached 600mb ram, not efficient enought for me sadly. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-22 : 07:26:24
|
| those are some heavy duty xml files...have you tried xmlSpy?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
IceDread
Yak Posting Veteran
66 Posts |
Posted - 2007-11-22 : 07:44:55
|
| I have tried it now and it was up in 538mb ram when i closed it down and the cpu for it was on 50%. Thanks again thou, only sad it aint as effective as I need it to be. The xml file I try to load is on 17mb. |
|
|
|
CmdrRicK
Starting Member
1 Post |
Posted - 2007-11-28 : 08:38:09
|
quote:
Originally posted by IceDread
I have tried it now and it was up in 538mb ram when i closed it down and the cpu for it was on 50%. Thanks again thou, only sad it aint as effective as I need it to be. The xml file I try to load is on 17mb.
the only xml tool I have found that can handle large xml files was xmlmarker from http://symbolclick.com/ it has one downside since it cannot handle unicode |
|
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-11-28 : 21:56:46
|
| Depending on what you're trying to do, you may be better off writing some code of your own. In the .NET Framework there are XML stream classes that do not load the whole file, but rather read through it as a stream, so it's fast without using massive amounts of memory even for very large files.Here's an example of validating a large filehttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=683898&SiteID=1 |
|
|
|
IceDread
Yak Posting Veteran
66 Posts |
Posted - 2007-12-07 : 04:01:12
|
| Thanks for the tips :) |
|
|
|
|
|
|
XML Tools available?