XML issues

Hi guys,
I'm having some issues using XML to store data in my application, I'm using ASP and XML to store user input such as comments and things like that.

Here are the questions to which I couldn't find the answers

1. What is the limit of the data I can store per node? ( <node>data</node> )

2. What about the limit of attributes in nodes? ( <node attr="data"></node> )

3. What would make more sence or be quicker to process using n.1 or n.2 above to store data?
4. When I create my elements in the XML file, they get all in the same line ( <node1><node2>data</node2></node1> ) for readability in dubugging mainly I would like it like:
<node1>
  <node2>data</node2>
</node1>
How to do this? In VB.NET they are created the proper way but not in ASP.

5. Paging, how to with XML?

6. Is XML viable to store large ammounts of information?

Thanks guys.

Thanks Mart.

3. I will now try to use attributes on one node only per post to store it's data, I also figured that by using attributes you save a great deal in file size, but I don't know how much data I can store, I haven't found anything on this.

5. Do paging with XML data in ASP.

6. Yes, I know the file is loaded in memory, but I will use one file per days worth of input, so the files will be named like (posts_08-apr-2005.xml) to get small files, thanks for reminding me of this issue.

-----------------------------------------------------

Anyone to help with points 1, 2, 4, and 5 above?

Thanks.

Thanks,

Questions from old bunch:

4. Does anyone knows how to break lines in XML files creating from ASP pages? All my elements going sideways one next to the other, I would rather have them going down.

5. How do do paging from XML data with ASP?

New question: How to do sorting, search, edit, update, delete, I can do inserts :) but the other operations are proving tricky, anyway has experience in this? I can't use SQL to query it can I? I heard of a COM for it, but I rather use native methods, anyone?

Almost there, but not quite :|

You can't use SQL to select data but you can use XPath

theSCIENTIST wrote: Thanks, Questions from old bunch: 4. Does anyone knows how to break lines in XML files creating from ASP pages? All my elements going sideways one next to the other, I would rather have them going down. 5. How do do paging from XML data with ASP? New question: How to do sorting, search, edit, update, delete, I can do inserts :) but the other operations are proving tricky, anyway has experience in this? I can't use SQL to query it can I? I heard of a COM for it, but I rather use native methods, anyone? Almost there, but not quite :|