SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Sql Server CE and Active Sync Degrading performance


Sql Server CE and Active Sync Degrading performance

Author
Message
niall.moore-945146
niall.moore-945146
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 6
I'm running Active sync between CE and Express every 5 mins. it starts off fine taking < 1min but gradually degrades to 30mins + after 10 hours or so (obviously not every 5 mins anymore) .

its the same amount of data each time 2 records created every 5 secs which are deleted after the sync.
Rebooting doesn't help. If I restart and sync with no data changes it still takes 30mins+

However if I rename the CE database and copy in an empty database (first sync creates the tables) it goes back to < 1 min/sync.

If I go back to the old database its back to 30mins+

The only variable here seems to be the CE database or how long it has been running. Both databases have the same tables and records after the first sync.

The database running for 10 hours has had lots of inserts/deletes is there some reason why performance would degrade over time.
office-746051
office-746051
SSC Rookie
SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)SSC Rookie (26 reputation)

Group: General Forum Members
Points: 26 Visits: 44
Hi,
You are a step forward... We are only going to change database contents of a Windows Mobile from a Desktop PC connected over ActiveSync.
On the mobile is a MS SQL CE 3.5 SP1 DB located. We would like to write and read some datas with a running Windows application on the desktop.
This should be possible: With SQL Server Manager Studio 2008 we are able to connect to the mobile database and modify data contents.

Have You sold this 'problem' or do You make 'only' a simple data synchronisation?

Best Regards:
Lesley
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search