Issues with Concurrent Threads

Jun 26, 2012 at 2:57 PM

 

Wrote a test that has 10 threads creating 1000 records. And tested the Auto Number. It fails drastically.

If anyone is interested in seeing the results send me an e-mail and I will send out a zip file.

10 threads each inserting 100 records.

Success: 733 / 1000
Fail Rate: 27.7%
Completion times:
Low – 2:12
High – 2:59

If you get different test results please post them.

It appears your code if it gets a duplicated fails the transaction and fails the create.

If I run one thread it works perfect and inserts 1000 records no issues. The records are created really fast. Run 10 threads and it fails drastically and runs really slow.

Because we can't see your code we have no idea way.

This will cause major issues in a production system. Call center with 200 users creating inquiries. You will have many failed creates.

Coordinator
Jun 26, 2012 at 5:49 PM

Hi crmDean,

Thanks for your feedback for this project.

Which CRM environment did you try running your test on?

As a part of our integration testing, we've created similar test cases as yours running on our CRM Online environment.

We modified our test to have 10 threads creating 100 records each and ran them against our CRM Online environment.

Here is the outcome.

All 1000 records were created successfully with the unique auto-number on each records. It took a little while to create these records as our CRM Online is located in Singapore and we ran the test from Australia. So there is a bit of latency there (>200ms).

Jun 26, 2012 at 7:28 PM

Run multiple EXE. See images. We tested in multiple environments. CRM Online running in US and Overseas as well as our own datacenter.

Description: cid:image001.png@01CD52CF.1ACB6E60

Description: cid:image011.jpg@01CD52CF.BF720140

Dean Jones CEO | www.PowerObjects.com | Mobile: 612-701-4017 | Email: dean.jones@powerobjects.com

Minneapolis | Dallas | St. Louis | Columbus

Description: service-smDescription: education-smDescription: powerobjects-smDescription: twitter-sm

From: xrmbits [email removed]
Sent: Tuesday, June 26, 2012 11:50 AM
To: Dean Jones : PowerObjects
Subject: Re: Issues with Concurrent Threads [advcrm2011autonumber:360981]

From: xrmbits

Hi crmDean,

Thanks for your feedback for this project.

Which CRM environment did you try running your test on?

As a part of our integration testing, we've created similar test cases as yours running on our CRM Online environment.

We modified our test to have 10 threads creating 100 records each and ran them against our CRM Online environment.

Here is the outcome.

All 1000 records were created successfully with the unique auto-number on each records. It took a little while to create these records as our CRM Online is located in Singapore and we ran the test from Australia. So there is a bit of latency there (>200ms).