I have implemented a send adapter based on the TranscationalAdapter sample
that reads messages and saves the data to several tables in an SQL Server.
I set the endpoint key to one of 10 different key (in
CreateEndpointKey()),
in order to get them sorted (as done in SortMessagesIntoBatches()) into as
few batches as possible. The messages is input in an receive ****t in one
batch (with perhaps 200-300 messages at a time), but in the send adapter I
can see that the messages is put into batches for only 1-2 messages at a
time? As this results in a large number of threads that simultanously
reads
the input this leads to concurrency problems when saving data to SQL
server.
Why isn't the messages sorted into larger batches?
Is there a way to limit the number of simultanous threads allowed to
access
my send adapter?
Any help is appreciated.
Regards;
/jb
