|
Home > Archive > Commerce Server General > February 2004 > REFRESH Catalog after change is . . .
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
REFRESH Catalog after change is . . .
|
|
| newsgroup user 2004-02-19, 7:36 am |
| Hi,
I need to know or verify that when you Refresh a catalog (from Bizdesk) is it the same as using the Full Text Catalog Wizard when you Right-Click the Catalog Table?
I use scripts in SQL to bring in all the updates for my catalog that has about 80000 line. But I notice that the changes does NOT show up immediately. If I do the Refresh then I can search the items i.e. those that were added and find them. However, since
the whole pint is to automate this I wanted to see if I can add some SQL code or RUN a stored procedure already exisiting or schedule to run the Full text Indexing on the catalog(after the initial WIZARD setup).
Can some one help with suggestions or confirm that these will do the same. Also I am not sure of the Refreshing of the Cache that the "REFRESH" in Bizdesk does.
| |
| Vinayak Tadas [MS] 2004-02-19, 12:35 pm |
| When you so a refresh Bizdesk does two things
1. Starts an incremental population of the fulltext indexes for all the
catlaogs. This is similar to what you can do through SQL enterprise manager.
2. Some of the CS2002 runtime components cache information to prevent going
to the database on every request If the information changes cliking on
Refresh will refreshs the information cached by these components
Thanks
Vinayak Tadas
Microsoft
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.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only. Thanks
"Jim B" <anonymous@discussions.microsoft.com> wrote in message
news:A1FE31F8-F143-4517-BC1D-47F102F35144@microsoft.com...
> Hi,
>
> I need to know or verify that when you Refresh a catalog (from Bizdesk) is
it the same as using the Full Text Catalog Wizard when you Right-Click the
Catalog Table?
>
> I use scripts in SQL to bring in all the updates for my catalog that has
about 80000 line. But I notice that the changes does NOT show up
immediately. If I do the Refresh then I can search the items i.e. those that
were added and find them. However, since the whole pint is to automate this
I wanted to see if I can add some SQL code or RUN a stored procedure already
exisiting or schedule to run the Full text Indexing on the catalog(after the
initial WIZARD setup).
>
> Can some one help with suggestions or confirm that these will do the same.
Also I am not sure of the Refreshing of the Cache that the "REFRESH" in
Bizdesk does.
|
|
|
|
|