| Derek Tan [MSFT] 2005-06-28, 5:52 pm |
| Thanks, Siddharth, for your suggestion.
Regards,
Derek [MSFT]
--------------------
>Thread-Topic: tracking items in bulk in BAM --Urgen Please help
>thread-index: AcV7lVSShe1/O3RZSv6T6ofReW+baQ==
>X-WBNR-Posting-Host: 69.233.88.231
>From: "=?Utf-8?B?c2lkZGhhdGg=?=" <siddhath@discussions.microsoft.com>
>References: <D8F7AB41-B0AB-4624-ADAC-94C6AA2CFECB@microsoft.com> <X4aIIc0eFHA.2656@TK2MSFTNGXA01.phx.gbl>
>Subject: RE: tracking items in bulk in BAM --Urgen Please help
>Date: Mon, 27 Jun 2005 20:56:14 -0700
>Lines: 117
>Message-ID: <3B25A73A-6D57-4911-8D05-EA7812E5EF1D@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.general:15046
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>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:
>
performance[vbcol=seagreen]
>
--
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.
|