我们有一个商业服务器2007网站,我们有几个目录。其中一个目录非常大(大约4Gb的xml数据)。在此目录(备件目录)中,我们有不同的"部分"。这些部分就像是自己的小目录。 部分对应于CS中的类别。每个部分/类别都有很多子类别/产品。当我们更新目录时,我们总是删除整个部分/类别及其子类别和产品。这就是我们所做的:
我们遇到的问题是,当我们导入目录(包含删除的目录和包含新数据的目录)时,网站会超时。在导入过程中没有人可以使用该网站。可能是什么问题?
TR 解决方案
您是否看到任何SQL死锁。如果是,您可以申请KB以下文章。
support.microsoft / KB / 2396957 功能
Hi,
We have a commerce server 2007 site where we have several catalogs. One of the catalogs is very big (about 4Gb of xml data). In this catalog (spare parts catalog) we have different "sections". The sections are like small catalogs in its own. The sections corresponds to categories in CS. Each section/category has a lot of child categories/products. When we update the catalog we always remove a whole section/category and its child categories and products. This is what we do:
The problem we have is that when we import the catalog (both the one with delete and the one with fresh data) the web site times out. No one can use the web site during the imports. What can be the problem?
TR 解决方案
Are you seeing any SQL deadlocks. If yes, can you apply below KB article.
support.microsoft/kb/2396957
更多推荐
我们的商务服务器站点在导入目录期间挂起/超时
发布评论