How do I build efficient category trees?

[Ted]

I am currently putting together an eCommerce site. I have almost everything
in place, but I am not happy with the category system for our products.

There are around 2500 products in a SQL Sever db, each assigned 1 of 300 odd
categories. Currently, I have statically built the category tree but wish to
automate this task as it is becoming increasingly difficult to manage.

I have googled plenty of info, specifically for ADO data shaping. Is this
the right route to take, especially considering each branch of the category
tree may differ in depth of categories? How exactly do other eCommerce sites
automate this task?

I would also want to be able to copy the category system that provides links
to previously selected categories i.e.

Category 1 > Sub Category 2 > Sub Category 3 > etc etc

Is this possible with the SHAPE command? Are there other methods of
performing this task?

I am particularly concerned about the database taking a major performance
hit from all of these SHAPE queries, which would be required on every
category page. Could I use a stored procedure, and how much would it improve
performance? Considering I will be hosting on a shared server, I want to
make this as efficient as possible.

Thanks,

Ted.

[[MSFT]]

Hi Ted,

We will use Shape command when we need to join tables, for example, orders
and orderdetails. With Shape, one record can have several child records. I
don't know the data structure of your database so that I don't think Shape
is a good idea for this issue.

Normally, we can consider MS SQL server OLAP service when we need to query
data from multiple dimesions (different categories). For more information,
you may take a look at following articles:

http://www.microsoft.com/resources/d...kit/en-us/part
9/sqc12.mspx

http://support.microsoft.com/default...;EN-US;Q213364

Hope this help,

Luke
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)