XML Virtual Memory Issue?

[Guest]

We have a 7.1meg XML file(15000 records) which we write to XML from a backend DB
We write the XML to a dataset and then populate a SQLCE DB from the XML file
The problem is we are running out of virtual memory on the PDA.
Can we stream the XML to the SQLCE without the use of a dataset
The XML file load on a laptop takes about 8 mins
Are there compression techniques etc ?

 

[Lloyd Dupont]

use ADO.NET !

open a connection to a sqlserver on the server !
open a connection to sqlce on the PPC

every time you read an IDataRecord from the server write it to CE !

 

[Ilya Tumanov [MS]]

Are you using schema to load XML?
7 mb XML is not that big and should not cause memory problems if you using
schema.
It most likely will with inference.

You can reduce XML size by not using nested relations and by mapping
columns as attributes.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------

Thread-Topic: XML Virtual Memory Issue?
thread-index: AcRJTMlevl9b3G+DQWuF/OGwL6ksGQ==
X-WN-Post: microsoft.public.dotnet.framework.compactframework
From: =?Utf-8?B?bWFyY21j?= <[email protected]>
Subject: XML Virtual Memory Issue?
Date: Thu, 3 Jun 2004 02:26:01 -0700
Lines: 6
Message-ID: <[email protected]>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.dotnet.framework.compactframework
Path: cpmsftngxa10.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.dotnet.framework.compactframework:54437
NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework

We have a 7.1meg XML file(15000 records) which we write to XML from a

backend DB.
We write the XML to a dataset and then populate a SQLCE DB from the XML
file.
The problem is we are running out of virtual memory on the PDA.
Can we stream the XML to the SQLCE without the use of a dataset.
The XML file load on a laptop takes about 8 mins.
Are there compression techniques etc ?