Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
xml row limit
- Thread starter lin73
- Start date
>I wonder if there are any limit on how many rows there can be in a single xml fil.
I don't think so. Or, bigger than any parser can reasonably handle in reasonable time frame. For big xml file, you do have to be biased to use event-driven parser rather than dom parser which parses it into memory. But I can't give considered benchmark figures to back it up. It sure exists out there articles better than this after some search.
I don't think so. Or, bigger than any parser can reasonably handle in reasonable time frame. For big xml file, you do have to be biased to use event-driven parser rather than dom parser which parses it into memory. But I can't give considered benchmark figures to back it up. It sure exists out there articles better than this after some search.
I've worked with XML files of more than 1gb in size. So the answer is no - your XML file can be as large as you need.
However, many of the tools currently available have significant problems with files that large. I had to write my own file handlers using SAX (a forward-only XML reader) because it just wasn't possible to load it into a DOM, or an editor like XMLSpy.
Chip H.
____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first
However, many of the tools currently available have significant problems with files that large. I had to write my own file handlers using SAX (a forward-only XML reader) because it just wasn't possible to load it into a DOM, or an editor like XMLSpy.
Chip H.
____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first
- Status