Jump to content

SyncCheck Deletion Issue


P J
 Share

This topic is 2599 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Tim,

 

I am still waiting (after 10 minutes on a wired DSL connection for a synccheck to process )  The issue is that I have a dozen records on the mobile device and over 200,000 on the Server!  Obviously this is going to be a serious performance hit! 

 

Do you have any bright ideas?

 

Thanks

 

Paul Jansen

Link to comment
Share on other sites

Paul --

 

Take a look at the "Sync Check" script in the hosted database. You might want to modify the SELECT statement for the table that has those 200,000 records in it so that it excludes the ES_Record_UUIDs for records that you are fairly certain the mobile device doesn't have copies of (old records, archived records, etc). The goal being to significantly decrease the number of UUIDs that EasySync needs to do the diff analysis against.

 

Another option, which would be more complicated, would be to develop a custom version of "Sync Check" for this database so that it creates the diff list in an entirely different way. It could loop over the UUIDs that the mobile device has sent, and then either do SELECTs or Finds against the ES tables to see if those UUIDs exist on the server.

 

Hope this helps. Let me know if you have additional questions or need assistance with optimizing the process.

 

Tim

Link to comment
Share on other sites

Tim,

 

Thanks for the input.  I like your idea of using SQL to check if the records exist.  I don't expect to have that many records on the mobile device.  How many values could I put in a SQL WHERE IN query?  I could query the hosted table in this way and then use the existing diff mechanism.  I guess I might need to split the WHERE IN into several queries if the ID count is too high - a bit like segments for the payload.

 

I am also thinking that I need to be able to use parameters to determine which SyncCheck deletion method (if any) to use.  I have a couple of tables where I can use cascading delete in the mobile file and so do not need to run syncCheck at all.

 

What do you think?

Link to comment
Share on other sites

In theory, the "IN" clause can be as complicated as you need it to be. I don't know that I would isolate specific records by ID, but instead using logic that makes sense based on the business case. For example, if you are working with a table of orders, maybe you can exclude large number of records based on the order date or status (or a combination of the two). You just need to be careful to only exclude records that there is no chance of the mobile users have on their devices.

 

-- Tim

Link to comment
Share on other sites

This topic is 2599 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.