09.02.2018, 03:19 | #1 |
Участник
|
gustafwesterlund: Deleting a lot of records fast
Источник: http://gustafwesterlund.blogspot.com...ords-fast.html
============== A quick one today... Needed to delete a couple of million records for a customer and the natural thing was to use the Bulk Deletion service, well, I turned it on and it was extremely slow. Only got about 10 records/s which would cause the entire delete to take over a week. I have checked with Micrsoft and this is not a bug, but it is working as designed and is not designed to be super fast. Personally I would like it to be when removing a lot of records cause sometimes you need to. I also checked to see how fast the deletion would be with SSIS and Kingswaysoft. Used the following settings:
So, want to delete a lot of stuff, maybe Bulk Delete is not the way to go. Not yet anyway, let's hope Microsoft makes it faster! Gustaf Westerlund MVP, Founder and Principal Consultant at CRM-konsulterna AB www.crmkonsulterna.se Источник: http://gustafwesterlund.blogspot.com...ords-fast.html
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору. |
|
|
|