Fastest way of parsing Xml and inserting data into a sqlce database that resides on a windows mobile device 6.1. RRS feed

  • Question

  • Hi,

    I am tring to download a 65 MB of Xml file from a ftp server.

    After downloading i am parsing the xml file using XmlReader  and pushing it into a single table in database (SQLCE). THis table has indexes applied.

    This table is only used for fetching values. After the application runs for few instances and the indexes take effect if I download the same XML file and replace existing set of data with new values then inserting values into the table takes more time.

    I guess this is happening due to indexes applied on the table.

    This time gradually increases if we perform the same activity over and over (ie. parsing the same XML to database)

    Can anyone suggest the possible solutions to it and best possible solution for bulk insertion.

    I am using Sql server compact edition 3.5 as database and C# as programing language.



    Thursday, October 21, 2010 10:50 AM