| siddhath 2005-06-28, 2:52 am |
| Hi Derek
Thanks for your reponse.
From your reply , I undestand that the bulk updates in BAM are not possible.
However it will be nice to have this feature.
I think you would agree...if you can update 10,000 rows in one shot by sql
statement like following..
Update BAm_<ActiveTable>
Set QueueName = 'NewQueueName'
where QueueName = 'OldQueueName'
you would not want to be running a loop of 1 to 10,000.. to do the same
irrespective if you use buffered stream...
Just a suggesion...may be there could be a concept of
"BatchActivityIdColumn" just like the activityID column already present in
BAM.
This will let us do bulk update (like the query above..i don't have to run
the loop) using BAM APIs which presently is not possible.
"BatchActivityIdColumn" column can be just one column or composite of
multiple columns.
I know there are great people sitting in MS but just thought to bring a
suggestion to their notice.
Thanks
Siddharth Khare
"Derek Tan [MSFT]" wrote:
> Hi Siddharth,
>
> Using the API is the way to go. You can set the flush threshold to 0 to do your own flushing outside the loop. This would not be a single update statement that you may desire. However, are you seeing performance
> issues when using the API? We have batching capabilities to reduce the number of round trips to Sql server. Also, if performance is really an issue, try using BufferedEventStream.
>
> Updating tables directly is not and will not be supported.
>
> Thanks,
> Derek [MSFT]
>
> --------------------
>
>
> --
>
> This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
>
> Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
>
>
|