Vinod Kumar[MSFT]
Guest
|
 Posted:
Wed Feb 16, 2005 10:51 pm Post subject:
RE: Can the ordergroup.tracking number be indexed ? |
|
|
Theoretically yes, But make sure to do some validations.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
--------------------
Thread-Topic: Can the ordergroup.tracking number be indexed ?
thread-index: AcUUMDrqotIL232mT+6fbI7lQsXoLg==
X-WBNR-Posting-Host: 15.211.169.100
From: =?Utf-8?B?UmF2aSBTaGFua2Fy?= <shankycheil@newsgroup.nospam>
Subject: Can the ordergroup.tracking number be indexed ?
Date: Wed, 16 Feb 2005 06:03:02 -0800
Lines: 14
Message-ID: <DA85A58D-5CAA-492D-92CA-963548427AC1@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.commerceserver.general
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: TK2MSFTNGXA01.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:2225
X-Tomcat-NG: microsoft.public.commerceserver.general
Hi,
We have a Commerce 2002 Site which is integrated with Navision through
BizTalk 2002. To handle order status notifications from Navision we use the
tracking number generated by commerce server during the order confirmation
field.
To locate the order for which the status needs to be update a call to
OrderGroupSearch is made using the tracking number and order date as the
fields. Can I improve the performance of this search if I were to index the
tracking number field in the database ?
--
Ravi Shankar |
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in