What helped in our case was to delete data from write optimized DSO and reload data again in BW. But this is just workaround and after some time it will slow down again.
There are 2 additional options:
1. Implement SAP note on write optimized DSO (I don't know the note number right now, but can be found if needed)
2. Change DSO type from Write optimized to Standard.