Re: Quick Question
From: Robert Bouillon (djwhizzard_at_hotmail.com)
Date: 10/04/04
- Next message: Jitendra Patil: "Re: RDA SubmitSQL and connection pooling"
- Previous message: Robert Bouillon: "RDA Versus Synchronization : Opinions Please"
- In reply to: Kevin Collins \(MS - SQL Mobile\): "Re: Quick Question"
- Next in thread: Kevin Collins \(MS - SQL Mobile\): "Re: Quick Question"
- Reply: Kevin Collins \(MS - SQL Mobile\): "Re: Quick Question"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 4 Oct 2004 11:07:37 -0400
I found my problem, but I'm not sure if it's a bug in SQL CE:
I let the sunc run its course, and after about 90 minutes it finally threw
an exception. It said something about an integiry violation which led me to
look at my filter joins defined in the publication. I forgot to add a join
to a table, which meant that what should have been ~3,000 or so records was
~90,000. The other ~87,000 records had integrity violations because thier
related data was missing from the publication.
Regarding the possible bug in CE:
Despite the fact that there were 80k records with broken relationships, why
did it take so long to break? My pub has 40,000 records as-is (in working
condition), and takes about 7 - 10 minutes to sync. Logically, I would think
120k records would take about 30 minutes. 90 minutes is a ludicrous amount
of time to wait for an exception. Perhaps SQL is throwing an error on every
record, and waiting until the end to throw an exception?
Also, Thanks for the information on RDA. I find myself relying on google and
NG's so much I forget how robust the BOL are. Great job on that, BTW. MSDN
makes me proud to raise the MS flag when Im asked what I primarily program
in. Of all the arguments that can be made, nothing compares to the dev
support in MSDN.
--ROBERT
"Kevin Collins (MS - SQL Mobile)" <kevincol@online.microsoft.com> wrote in
message news:OKV8GvAqEHA.3980@TK2MSFTNGP12.phx.gbl...
> Our books on line that comes with VS 2003 and our server side installation
> package goes into detail about RDA.
>
> Search for Using Remote Data Access in the BOL and that will provide you
> with an entire overview and code samples. With VS 2003 there is code
> samples that use RDA.
>
> There are some things to look at for merge replication, but I don't know
> enough from the information that you are providing.
>
> You can watch this web cast and at the end of it there are tips on merge
> replication performance optimizations. They may or may not be applicable
to
> you.
>
> http://24.17.112.250/SQLMobileWebCasts/mbl348.wmv
>
> You also can try dropping your publication and then recreating it. If it
is
> fast then, then that will answer some questions for me.
>
>
> "Robert Bouillon" <djwhizzard@hotmail.com> wrote in message
> news:eZd0I$9pEHA.1960@TK2MSFTNGP10.phx.gbl...
> >I do wish to synchronize the rest of the database, but not as frequently.
> > I'll look into RDA. Do you have a link to some more information on how
to
> > do
> > this?
> >
> > Also, my synchronization seems to hang now. The initial subscription
used
> > to
> > take about 5 minutes. I gave up after 30.
> >
> > Are there common reaons why a subscription would hang? I'm using the
> > emulator. The CE database between 5 and 7 MB (Was 5.5 on last successful
> > subscription). My SQL DB is on the same machine as IIS.
> >
> > Thanks.
> >
> >
> > "Kevin Collins (MS - SQL Mobile)" <kevincol@online.microsoft.com> wrote
in
> > message news:ejYoV19pEHA.3424@TK2MSFTNGP12.phx.gbl...
> >> If you never want to bring rows down to the device, but only send rows
up
> >> and only for one table, then your best bet is to use RDA and use a PULL
> >> statement with the SELECT statement that you specified below (with
> > tracking
> >> turned on).
> >>
> >> Assuming that is all that you want to do RDA will be the most efficient
> > and
> >> easiest sync technology for you to use. No use using merge replication
> > and
> >> taking the overhead of additional functionality that you will never
use.
> >>
> >>
> >>
> >> "Robert Bouillon" <djwhizzard@hotmail.com> wrote in message
> >> news:%237aLXT9pEHA.1668@TK2MSFTNGP14.phx.gbl...
> >> > I'm fairly new to the SQL Replication end of things, so I have an
easy
> >> > question:
> >> >
> >> > I'd like to designate one table on the SQL CE database that is
> > write-only.
> >> > I
> >> > don't need any records from the publishing database, I only need to
add
> >> > new
> >> > records.
> >> >
> >> > In the publication Properties, I was thinking of adding a "WHERE 1=0"
> >> > to
> >> > the
> >> > filter to prevent any rows from propogating to CE. Will they make the
> >> > return
> >> > trip? Also, is this the best way?
> >> >
> >> > Thanks.
> >> >
> >> > --ROBERT
> >> >
> >> >
> >>
> >>
> >
> >
> >
>
>
- Next message: Jitendra Patil: "Re: RDA SubmitSQL and connection pooling"
- Previous message: Robert Bouillon: "RDA Versus Synchronization : Opinions Please"
- In reply to: Kevin Collins \(MS - SQL Mobile\): "Re: Quick Question"
- Next in thread: Kevin Collins \(MS - SQL Mobile\): "Re: Quick Question"
- Reply: Kevin Collins \(MS - SQL Mobile\): "Re: Quick Question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
