I have a 2Gb YXDB consisting of about 40 columns and 7.5M rows. It takes forever to write its contents on MS SQL server (5% took about 5 hours, I had to cancel because VPN connection has to be re-established every 24 hrs).
Are there best practices or ideas to (attempt to) improve the speed of writing?
Attaching the sample workflow.
Thank you in advance!!
BDB
Solved! Go to Solution.
use datastream in? What's up with your odbc configuration? tbh - this should run in under an hour depending upon your network connection. worth looking at your resource manager to see where your bottlenecks are. I'd shut down chrome/anything else network related if it's at your network level.
just to close the loop on this question, I solved this issue by using Data Cleansing and Auto Field tools during the YXDB creation, and re-establishing ODBC via DCM. It takes about 2 hrs to push on the SQL server.