SQL CE Push ConnectTimeout

My application synchronises data with a SQL Server using RDA, the synchronisation process take place in a background worker thread.

Due to the single connection limit with SQL CE 2.0 the form thread has to wait until the synchronisation process completes before connecting to the database to perform any updates or inserts.

Normally the RDA push method executes quickly and the delay on the form thread is not noticeable. However CPU usage on the SQL Server can seriously affect the duration of the Push and consequently the form thread can appear to hang, not good from a user point of view.

Is there anyway to set a maximum Push duration or limit the number of records to be pushed back so I can predict the wait on the form thread.

Thanks in advance...

Answer this question

SQL CE Push ConnectTimeout

ericsdavis
Hi Glynndon,

Iam using SQL Server Mobile (SQL CE 3.0). I think my problem could be similar to yours, I dont get a connection time out, iam not using threadding but the Application and whole PDA locks up when i try to write to the database after performing merge replication.

The is no answer as yet that solves it. Could you check it out and see if you have encountered the same problem.

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=138546&SiteID=1

Thanks,
pdns
deerchao
Thanks for the reply but not very useful...

Does RDA performance suffer when run in a background worker thread
Analog
Answering your second question - You wont be able to limit number of records to push.
Chris Rossall
The correct way to use - Not to use DB in separate threads.
You can do this in SQL Mobile (SQL CE 3.0) but not in SQL CE 2.0
SQL CE Push ConnectTimeout

Answer this question