Daniel Cai

Here comes the Community Summit 2023 in Charlotte

To properly test the new xMultiple support, you need to set the batch size to 20+. You could do something like 25, 50, 50, 100, or even 200. xMultiple is only enabled when the batch size is greater than 20, this is by-design, we might lower the threshold in future releases.

We have just made our 2023 release wave 2 available. Anyone wants to try out the new #xMulitple support and see how much performance improvement you get? Our preliminary tests show it is about 2 times faster, but I suspect that you can do better. #Dynamics365 #dataload

In case you have missed it, our 2023 Release Wave 1 has been made available on March 17, 2023, which is packed with over 265 new features, updates, and enhancements, including 12 new APIs. kingswaysoft.com/about-us/news/… #KingswaySoft #DataIntegrationMadeEasy #SSIS #ETL

@mrdang Glad to hear that you are fine.

I am alive. A car just ran into my bike's front tire. I wear an obnoxiously bright helmet and a bright jacket. But I'm invisible if a driver doesn't look out for me. If you don't want to murder a biker, please put down the phone and look both ways.

@ddlabar @kingswaysoft That is a lot of records to go through. :)

@danielcai @kingswaysoft Around 200GB

Anyone forget to disable plugin trace logging and *slightly* overuse their allocated Logging space? I've started a Bulk Delete but it's going to take at least a week, and I will need tracing sooner than that. Anyone know if support has a method of clearing that faster?

@ddlabar @kingswaysoft Just curious, how many records were you deleting? Gustaf has an interesting blog post from 2018 - gustafwesterlund.blogspot.com/2018/02/deleti…

@danielcai @kingswaysoft MS support was able to actually truncate it within a day.

@ddlabar @kingswaysoft Bulk Delete is mainly designed for scheduled deletion. The feature name has confused most people. And it is intentionally engineered to be slow to protect the system, and as a matter of fact, it is awfully slow.

@ddlabar In contrast to what most #Dynamics365 developers believe, Bulk Delete is the slower version of deleting operation. If you want to have many records removed instantly, you'd use the Delete action. You'll need multi-threading to speed it up. @kingswaysoft can make a big difference

KingswaySoft's SSIS Productivity Pack has received the Google Cloud Ready - BigQuery designation, which certifies our solutions fulfill the core functional integration requirements. Read more! kingswaysoft.com/about-us/news/… #DataAnalytics #BigData #Data #DataScience #DataCloudSummit

@scottsewell @kingswaysoft Thanks Scott for bringing up the memory - I vividly remember the time at the Summit. Thank you for all your support throughout the years, particularly those creative suggestions. If I'm given another opportunity, I'd choose a different name for the dummy destination component. 😀

@qmiswax @kingswaysoft Thanks @qmiswax for your support over the years, much appreciated.

Just reading @kingswaysoft newsletter and KingswaySoft Celebrates 10th Anniversary, congratulations are in order, still remember early version used successfully on large Dynamics project and great support from @danielcai , wish you many more anniversaries.

@adfcbiker @crmgustaf @kingswaysoft Good question. Those settings have been in our software for a few years. So yes, the optimization was baked in since we introduced the multi-threaded writing capabilities. For affinity cookies, we don't actually support those cookies from the beginning, so they are never on.

@crmgustaf @danielcai @kingswaysoft These ones. They have huge impact even in on-premieres scenarios

Are Microsoft's official recommendations wrong? I think they are. Read more here: powerplatform.se/incorrect-api-… #microsoft #PowerApps #powerplatform #dataverse

How to use @kingswaysoft with Dataverse for Teams (DV4T). Thank you @danielcai for showing me the new connector ❤🤗 crmkeeper.com/2021/08/03/ssi…

We are delivering two training sessions on SSIS development and our #Dynamics365 toolkit next week. Included in the training is a 30-day free access to our online training platform of the same content at training.kingswaysoft.com. Sign up before the seats are sold out.

@dantaspower @kingswaysoft Awesome, it must be very delicious. :)

Always a good choice on the grill or in your SSIS packages!!! 🥩 @danielcai @kingswaysoft #PowerCommunity #PowerPlatform #MyKindOfBroccoli

@rappen Love the spirit. You are doing great, Jonas - thanks for the inspirations!

Teaser 3. It feels a light bright white. I can not wear black t-shirts no more. #stroke #strokesurvivor #imlight (full teaser fixed!)

@peterbjorkmark @crmgustaf @KhanAli Someone in Microsoft should fix the writing. I get the points they try to make, but this recommendation doesn't stand in court. I believe using batch is beneficial for performance. I agree we should be gentle with the setting, use a batch size of 10 so we don't push hard on them

@peterbjorkmark @crmgustaf @KhanAli Thanks Peter for sharing the experience, appreciate it. I agree with your assessment earlier, I believe Microsoft recommends not using batch for the same reason that they don't want all the loads to get processed on the same server, which affects the serviceability of the server.

Batching is not recommended if you use the WebAPI due to small payloads. That was news to me, but maybe I am just late to the game. #avoid-batching" target="_blank" rel="nofollow noopener">docs.microsoft.com/en-us/powerapp…

@rappen Great to see the smile Jonas, admire your toughness. Get well, hope to see you soon.