OpenSync

Home Forums OpenSync Opensync 3.0.28 performance issue

This topic contains 13 replies, has 6 voices, and was last updated by  Yudel Rosales 2 days, 7 hours ago.

Viewing 14 posts - 1 through 14 (of 14 total)
  • Author
    Posts
  • #66512

    Paul
    Participant

    Over the last 3 weeks I have been having real performance issues with OpenSync. I was using QB 2019 Pro and doing a Refresh All (one way from QB to MS Access) would take a couple of minutes to run. A Populate all would take a lot longer but maybe only an hour or so. I upgraded to 3.0.28 and don’t recall any performance change. However within a week all tasks became much slower ie 16 minutes for a refresh and 6.5 hours for a populate. I have tried lots of things to solve the problem but nothing seems to work. My IT tech has looked at our server and can’t find anything causing an issue. I have upgraded to QB 2020 but this has made no difference. My QB datafile (.qbw) is over 500MB so I tried a different QB company with file of 160MB and it is still really slow. So I want to try going back to a previous version of OpenSync maybe 3.0.25 to see if this helps but need that installation file. Can you provide that or help in any other way.
    Thanks

    #66516

    Yudel Rosales
    Keymaster

    There was no change that can compromise speed between .25 and .28. Did you get another software installed in your system or you to have more users of QuickBooks? It has to be something because there is no change that could affect the speed.

    #66734

    robert3
    Participant

    I am noticing a similar issue after an upgrade from 3.0.25 to 3.0.28. My daily update tends to lag on refreshing the itemsites table. It seems to take an hour or more to refresh on version 3.0.28 when it only took about a few minutes on version 3.0.25.

    It seems to run two sets of data. The first set is around 9,000 records and runs about 10 records a second. The second data set is about 5,000 records and runs about 1 record a second.

    #66741

    robert3
    Participant

    There is definitely a performance issue with 3.0.27 and 3.0.28.

    I downgraded to 3.0.27 and the itemsites table was on track to take well over an hour. I downgraded even further to version 3.0.18 and the speed is down to 2 minutes.

    Any way I can get a download link to 3.0.25?

    #66750

    Yair
    Participant
    #66751

    robert3
    Participant

    Thanks, Yair!

    #66787

    raymond1
    Premium Member

    Yair – thanks for posting the link… I’m going to see if .25 solves my issue with .28….

    Raymond

    #66788

    raymond1
    Premium Member

    Update – .25 did not have the same issue as .28.. but .25 will not run with QB20 so I’m back to square one…

    Raymond

    #66797

    Yair
    Participant

    @raymond1 I have the same problem with .25 that it crashes only when deleting a task.
    plus once it crashes it still keep the setting before it crashed.

    but I use OpenSync Configure only once and then re-run the same task.

    if you want to modify a task manually you can go edit
    C:\Users\yaya\AppData\Local\Synergration\OpenSync\OSconfig.xml

    it is where all the tasks are stored the Password is stored in a format of ESD not if you can’t generate ESD format I would install OPenSync trail on another PC and try copying the settings.

    #66837

    Yudel Rosales
    Keymaster

    @raymond1 the issue here is seems to appear after you change to another computer. The problem that you are having is related to your new setup. That is what we need to find. Because from .25 to .28, the updates are really minor.

    #67460

    store
    Participant

    Hello Yudel, I have had the same issues when I upgraded to .28. As I was still at QB 2019 at the time I downgraded again to .25. Unfortunately I had to upgrade to QB 2020 and the performance of the .28 is 2x slower compared .25. I confirmed this after upgrading to .28 and running QB 2019. Upgrading QB to 2020 made no change in speed for .28.

    Thanksfully my MySQL database is populated right now, however I think it would take many days for it to repopulate if anything would go wrong with my database.

    #67476

    Yair
    Participant

    if you re-build QuickBooks database OpenSync will force you to repopulate your Database.
    so take note of that!

    I re-build QuickBooks database First weekend of every month, due to the continuous error QuickBooks manages to generate and performance slowdown without it.

    with the amount of data we have, it takes around 35 hours to repopulate the tables.
    recommended running the populate on Single user mode in QuickBooks.

    If you have a lot of free time and you need fast repopulation, try the following.
    set multiple VMWARE having QuickBooks and a backup of the QB file + OpenSync, each one will populate a different table to the MYSQL. all running in single-user mode and to the main DB.
    You can also populate with the filter of dates so Multiple VMWARE can “Populate the same Table”

    Invoice/Estimate/transaction tables are reasonably fast.
    “receive payment” table takes forever.

    I am using ver 0.25.

    #67490

    store
    Participant

    Thanks, Yari, I, unfortunately, need to repopulate a table – and it’s taking a very long time. I’m populating against a MySQL Database on a separate server. Older versions of opensync were never this slow, I’m at 3.0.28 due to QB 2020. I’m considering moving the MySQL server to the same server QB is installed at, but I think it’s more the querying of QB that’s taking such a long time.

    #67498

    Yudel Rosales
    Keymaster

    Use Refresh from QuickBooks on your daily task. You can change that on editing the task where it says “Operation”. If you pick Populate, it will transfer all the records each time. which takes longer every day.

Viewing 14 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic.