I wrote up a utility program to generate test data. Given a set of systemusers it generates N contacts for each and a bunch of accoutrements for those contacts (a mix of associated custom entities and activities.) In an effort to speed it up
I modified it to run one user and started it up two Command prompts each processing a different user. Only one survives. They go along for a while until one fails with Generic SQL Error. I also tried 16 command windows -- the more "threads"
the faster the failures of all but one.
What puzzles me is that one would think this is analogous to 2 or 16 users at once. All the transactions are creates -- nothing is writing to the same record -- except for the uncharted javascripts & assemblies. By uncharted I mean I don't
know what all is going on in the background.
So, I guess the question is, is such failure to be expected? If not, is the problem infrastructure/throttling of some sort or certainly due to collisions in background processing?
Your thoughts are appreciated.
md
PS- it is not like multiple users in that all "threads" use the same credentials.
