Re: failed alternative XML file approach against slow SqlCE bulk inser
- From: "Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx>
- Date: Sat, 1 Jul 2006 09:11:50 -0400
Arif,
One of my clients has a 65,000 record SQL Mobile file. It does take a long
time to load, even on the desktop, so they plan to load the file each night
as a scheduled process and copy it to the devices each morning. But the file
runs fine on the device and you can locate the record you want almost
instantly using the primary key. For the moment loading the file on the
desktop requires that the desktop is either a dev machine (SQL Server
Developer for only $50 qualifies) or a TabletPC, but when SQL Server
Everywhere is released around the end of the year, that restriction goes
away.
RDA would not really speed up the process for your client since the Pull
process of RDA needs to pull the entire file each time. Merge replication
would allow your client to do the time-consuming initial snapshot once and
then have just the changes brought down to the device afterwards, but as you
point out it is somewhat complex to set up.
--
Ginny Caughey
..NET Compact Framework MVP
"Arif" <Arif@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E9158167-736F-4F4C-B88F-B23E00550C3B@xxxxxxxxxxxxxxxx
Hi all,
There are 50,000 records in a text file that I import to SqlServerCE so
that
I can start inventory process.
But due to a slow performance of .NET CE it takes a significant amount of
time.
I decided to create an XML file for these 50,000 items on my desktop, then
to load this file using DataSet.LoadXml() method, so that I can escape
from
inserting these 50,000 items to SqlCE. For a 3MB text file the generated
XML
file is of 15 MB size that is impossible to load on Pocket PC due to
memory
problem.
Is there anyway that I can achieve my goal.
Although RDA method can speed up my process but my client may not be ready
to get involve in some more complex tasks.
Regards,
Arif.
.
- Follow-Ups:
- Next by Date: Re: failed alternative XML file approach against slow SqlCE bulk i
- Next by thread: Re: failed alternative XML file approach against slow SqlCE bulk i
- Index(es):
Relevant Pages
|
