We have launched a init load (infopackage 0CRM_COMPLAINTS)(BI 7.0) which extract 180201 claims from our CRM 2007 system.
The first packet (data package size 5000 records) have been extracted in 5minutes, but when it begins the 10 packets, it last 20min and 30 between each of them.
This treatment lasted 12 hours (we don't see optimization point at the moment)
The first thought is to decrease packet size but I don't find specific note about this problem, or any lead.
Any help will be grateful.