Page 1 of 1

Different behavior between push & pull

PostPosted: Mon Nov 16, 2015 2:36 am
by cotejf
Hi guys,
there is something strange in my setup. I think I did something wrong.

I have 1 table with 10k records. If I setup this table to sync from the mobile to the host only and if I only modify, lets say, 2 records, it synchronizes in 1 second.

If I change the setup and go for a full round trip, even if I change nothing on both sides, it takes like 10 minutes. Just to be sure, I resync'd immediately once finished and it took another 10 minutes.

Is it normal? Or am I missing something?


Thanks in advance

Re: Different behavior between push & pull

PostPosted: Mon Nov 16, 2015 2:44 am
by cotejf
Here is the log:
Code: Select all
11/16/2015 5:34:20 AM - Started

 Split     Total
---------------------------------------------------------
0:00:00 - 0:00:00 - Connecting to server...
0:00:01 - 0:00:01 - Getting settings from Host...

---------------------------------------------------------
0:00:00 - 0:00:01 - STARTING POSTAL_CODE ROUND TRIP

0:00:00 - 0:00:01 - Starting Push
0:00:00 - 0:00:01 - Starting to Push "gzm_Postal_Code"
0:00:00 - 0:00:01 - FLM is OFF
0:00:00 - 0:00:01 - Found 0 records to push
0:00:00 - 0:00:01 - Done Pushing "gzm_Postal_Code"

0:00:00 - 0:00:01 - Push Complete

0:00:00 - 0:00:01 - Starting Pull
0:00:01 - 0:00:02 - Starting to Pull "gzh_Postal_Code"
0:00:00 - 0:00:02 - Last Time Zync: "11/16/2015 5:32:44 AM"
0:00:00 - 0:00:02 - FLM is OFF
0:00:00 - 0:00:02 - Starting Perform Script On Server to get IDS - "gzh_Postal_Code"
0:00:00 - 0:00:02 - PSOS call complete
0:00:00 - 0:00:02 - Looking for record to Delete
0:00:00 - 0:00:02 - No records to delete in "gzm_Postal_Code"
0:00:00 - 0:00:02 - Deletion Complete
0:00:00 - 0:00:02 - Found 9808 records that have changed since last zync
0:00:00 - 0:00:02 - Starting sync on 9808 records.
0:07:57 - 0:07:59 - Sync complete!
0:00:00 - 0:07:59 - Done Pulling "gzh_Postal_Code"

0:00:00 - 0:07:59 - Pull Complete

0:00:00 - 0:07:59 - ENDING POSTAL_CODE ROUND TRIP
---------------------------------------------------------


0:00:00 - 0:07:59 - All Done








  _  _ ____ __   __      ____ _  _ __ _  ___ ____ ____
 / )( (  __(  ) (  )    (__  ( \/ (  ( \/ __(  __(    \
 \ /\ /) _)/ (_// (_/\   / _/ )  //    ( (__ ) _) ) D (
 (_/\_(____\____\____/  (____(__/ \_)__)\___(____(____/


Re: Different behavior between push & pull

PostPosted: Mon Nov 16, 2015 12:27 pm
by DanW
Hi JF,

Thanks for reaching out on this -- and thanks for the additional info.

No, this isn't normal! GoZync should only pull records that have been changed since the last sync. There are a couple things that could cause this behavior, but the likely one is a difference in date formats. Following the instructions at the link below, create a clone of your GoZyncMobile file. The cloned file should take on your system's date format (matching the format of your other files you've created). Let me know if using this new GoZyncMobile file causes the sync to work as expected!

http://www.seedcode.com/pmwiki/pmwiki.p ... ateFormats

Thanks again,

Dan

Re: Different behavior between push & pull

PostPosted: Mon Nov 16, 2015 1:18 pm
by cotejf
Thank you sooooo much! Omg, it is now lightning fast.

Honestly, you made my day. Thanks! ;-)

Re: Different behavior between push & pull

PostPosted: Mon Nov 16, 2015 3:10 pm
by DanW
JF,

Awesome! I'm so glad that worked for you. Thanks for letting me know.

Keep us posted if you have any further questions!

Dan