Tagged: rebuild populate
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.
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.
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.
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?
Yair – thanks for posting the link… I’m going to see if .25 solves my issue with .28….
Update – .25 did not have the same issue as .28.. but .25 will not run with QB20 so I’m back to square one…
@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
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.
@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.
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.
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.
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.
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.
Yair, i can explain how to get around repopulating everything. i’m not sure if it’s allowed to put contact info. if not i apologize in advance. email@example.com
basic steps go like this.
1. during a period when no new transactions go into qb.
2. refresh all tables you usually refresh just before qb rebuild.
3. do qb rebuild
4. go to database where opensync loads data
5. find table called history
6. update history datestamp for tables you loaded earlier to current date and time. date and time should be after qb rebuild and before any new transactions.
7. these steps will eliminate the need to populate after qb rebuild. when you do qb rebuild the lastmodified date is updated on most or all records in qb file. this is what triggers opensync to reload everything.
8. normal refresh task will work as expected
Happy to answer any questions. Jim.
You must be logged in to reply to this topic.