Very slow speed adding Rows to Dataset

[DotNetFAQ]

I need to insert rows to a database table after processing a piece of an XML file.

The XML file would look something like:

<Book>

<Chapter>

<Page>

<Paragraph>
<Paragraph>

</Page>

</Chapter>

</Book>

The table I am inserting data into is for the paragraph node. If there are 10 Books, with 12 chapters each of which has 30 pages and each page having Paragraph, then I am talking about ~3600 rows.

Below is the pseudo code for how I am doing this: Its very very slow. It takes about 10 mins to insert 3600 rows. I need a faster way. Can someone please help ? (table.NewRow() seems to be taking a lot of time, about 1 min for approx 360 rows.)


Create connection;
Fill dataset ds;

foreach (XmlNode book in Books)
{

XmlNode Chapters = book.SelectNodes("Chapter");

foreach (XmlNode chapter in Chapters)
{
XmlNode Pages = chapter.SelectNodes("Pages");

foreach (XmlNode Page in Pages)
{

XmlNode paras = Page.SelectNodes("Paragraphs");

foreach (XmlNode para in paras)
{

DataTable table = ds.Tables["Para_table"];
DataRow row = table.NewRow();

row[0] = para.Attributes["text"].InnerXml;
row[1] = Page.Attributes["pageno"].InnerXml;
row[2] = chapter.Attributes["chapterno"].InnerXml;
row[3] = book.Attributes["title"].InnerXml;

table.Rows.Add(row);

}

}

}

}