RE: Data Insertion

From: Dave (anonymous_at_discussions.microsoft.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 12:01:08 -0800

Hi Ilya,

Thank you for your help.
I have followed your suggestions.

Loading a file of more than 4 mb into a dataset is using up lots of memory.
The loading and insertion of the data is taking some twenty minutes.
Doesn't this seem very , very long?
Are there any benchmarks for data insertion with SQL CE and ADO.net?

It does not seem pratcical to load all the data into a dataset even using an embedded schema , reading the schema and then reading the data ignoring the schema .
The dataset solution does not seem to be a practical solution.

Do you have any idea if this technology is intended to be used on a PDA with a file of this size.
Do you have any other suggestions?

If I was to use the XMLTextReader method then repeatedly using a command object with ExecuteNonQuery and adding the records one by one is this going to be any slower than the dataset method?

Thanks for all your help,
Dave

Relevant Pages

  • Re: annotation issue with SQLXML - BulkLoad
    ... I will try to help you with this (by modifying the second schema as you requested) ... Are you loading this data to a single table? ... One with anotated XML and one without, just like the schema files we have. ...
    (microsoft.public.sqlserver.xml)
  • RE: Data Insertion
    ... You _have_ to use schema to accomplish that, ... Inference is OK for prototyping and, may be, loading 1-2K XML files; ... Change your XML file to contain embedded schema. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Load Data to SQL SERVER
    ... This depends a lot on how much data you have to load and how complex the ... schema you're loading it into is. ... Updategrams are not really suited to ... schema to map the XML schema to the database schema. ...
    (microsoft.public.sqlserver.xml)
  • Re: xml elements schema context
    ... ah, and I want to add, that it should allow any schema, especially ... recursive ones (so the path of loading the xsd to a dataset and then ... Prev by Date: ...
    (microsoft.public.dotnet.xml)