|
Home > Archive > Commerce Server Catalog > October 2006 > Catalog System Database Schema Question
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 |
Catalog System Database Schema Question
|
|
| Dave Marini 2006-10-10, 7:25 pm |
| In the Catalog Database there is a table for each catalog called
CatalogName_ProductCatalog. It appears that each variant property I create
gets appended to this table as a column.
Is this how all variant properties for a catalog will be handled? Isn't max
row length still 8k? so technically, if I had a product with a higher than
average amount of variants, couldn't I technically have a data trunc problem?
Just curious, Thanks
Dave
| |
| Vinayak Tadas[MSFT] 2006-10-28, 1:33 pm |
| Yes the 8k row limit still stands if you are using Sql Server 2000
Have you considered using Text properties instead of string properties.
Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt
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
--------------------
Thread-Topic: Catalog System Database Schema Question
thread-index: Acbsrn6g7PCB98hHSW6+f4mj8QQmQw==
X-WBNR-Posting-Host: 155.37.194.78
From: =?Utf-8?B?RGF2ZSBNYXJpbmk=?= <DaveMarini@discussions.microsoft.com>
Subject: Catalog System Database Schema Question
Date: Tue, 10 Oct 2006 13:56:01 -0700
Lines: 11
Message-ID: <0E6C7C1D-5AD4-4B0A-ABF3-8646C82CB08C@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.1830
Newsgroups: microsoft.public.commerceserver.catalog
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.catalog:6434
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.catalog
In the Catalog Database there is a table for each catalog called
CatalogName_ProductCatalog. It appears that each variant property I create
gets appended to this table as a column.
Is this how all variant properties for a catalog will be handled? Isn't
max
row length still 8k? so technically, if I had a product with a higher than
average amount of variants, couldn't I technically have a data trunc
problem?
Just curious, Thanks
Dave
|
|
|
|
|