Production vs. Sandbox - Performance
I recently ran a test or an existing DTS job in our Sandbox and the updates took about 1.2 seconds per record. I ran batches of 1000 records through and checked the table update timestamps.
Based on 1.2 seconds per record, I proceeded to load the QUEUE in Production with 75,000+ records. I figured that the Production environment would be “faster” and have been monitoring the update timestamps in production as I had done in the Sandbox.
Our production timestamps are averaging between 5 – 7 seconds per record.
Could the support team contact me and assist with troubleshooting? Is it possible to review how we have “threading” set on this server? Maybe our something is set differently in the Sandbox server vs. production server?