Hi Chuck,
The speed of adding data depends on many factors. Since the CPU of embedded
devices are always not as fast as desktop PCs', we cannot expect it to
perform as SQL server does. So I think adding 30,000 records might take a
long time for it.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
--------------------
| Content-Class: urn:content-classes:message
| From: "Chuck" <
[email protected]>
| Sender: "Chuck" <
[email protected]>
| References: <
[email protected]>
<
[email protected]>
| Subject: RE: Fastest way to load new table from dataset
| Date: Mon, 3 Nov 2003 06:26:38 -0800
| Lines: 88
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcOiFn3MxgKpBzC8RxSlftz5C8ujNA==
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:65206
| NNTP-Posting-Host: TK2MSFTNGXA08 10.40.1.160
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| I need all the records because they are lookup values.
| CE is only inserting about 10 records/second, which is
| extremely slow.
|
|
| >-----Original Message-----
| >Hi Chuck,
| >
| >I don't think it's the performance problem of SQL CE.
| Since SQL CE is only
| >a small engine on mobile device, it's not suitable for
| holding so many
| >data. I think you needn't download so many data at one
| time, you can only
| >dump what you need.
| >
| >Kevin Yu
| >=======
| >"This posting is provided "AS IS" with no warranties, and
| confers no
| >rights."
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Chuck" <
[email protected]>
| >| Sender: "Chuck" <
[email protected]>
| >| Subject: Fastest way to load new table from dataset
| >| Date: Fri, 31 Oct 2003 07:47:41 -0800
| >| Lines: 35
| >| Message-ID: <
[email protected]>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| >| Thread-Index: AcOfxlFKAZZDYFXnTkaeBB786vXhyA==
| >| Newsgroups: microsoft.public.dotnet.framework.adonet
| >| Path: cpmsftngxa06.phx.gbl
| >| Xref: cpmsftngxa06.phx.gbl
| microsoft.public.dotnet.framework.adonet:64991
| >| NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
| >| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| >|
| >| On a pocketpc 02 with sqlce
| >| I get a dataset with 30,000 records from a webservice
| >|
| >| I then load this dataset into a empty table that has no
| >| indexes or constraints. The load takes 50 minutes,
| which
| >| is about 49 minutes to long. Is there a faster way to
| do
| >| this?
| >|
| >| Dim cmd As New SqlCeCommand
| >| cmd.Connection = Globals.conn
| >| cmd.CommandText = "INSERT INTO cde_locations (LOC_cd,
| >| LOC_DESC, CLR_REQ) VALUES (? ,?, ?)"
| >|
| >| p0 = New SqlCeParameter("LOC_cd", SqlDbType.NVarChar,
| 3)
| >| p1 = New SqlCeParameter("LOC_DESC",
| SqlDbType.NVarChar,
| >| 80)
| >| p2 = New SqlCeParameter("CLR_REQ",
| SqlDbType.NVarChar, 1)
| >|
| >| cmd.Parameters.Add(p0)
| >| cmd.Parameters.Add(p1)
| >| cmd.Parameters.Add(p2)
| >|
| >| Dim ws As New xx.TRU_Services
| >| ws.Timeout = -1
| >|
| >| Dim ds As DataSet
| >| Dim drow As DataRow
| >| ds = ws.get_Loc_CodesDS
| >|
| >| For Each drow In ds.Tables(0).Rows
| >| p0.Value = drow(0)
| >| p1.Value = drow(1)
| >| p2.Value = drow(2)
| >| cmd.ExecuteNonQuery()
| >| Next
| >|
| >
| >.
| >
|
