Windows Server

Smitty200 · Guest

Our catagory pages display 8 items per page and then page numbers a
the top to display the each page of 8 items. When the number of page
moves above 4-5 for a category the page takes a long time to load. I
there is 4 or less pages load time is acceptable. I am new t
commerce server and have inherited site that was coded off shore
Should I look at the SQL tables for indexing optimization first? I
there any suggestions for what i should be looking for
Any help would be very much appreciated

Vinayak Tadas[MSFT] · Guest

Are you using CS2000 or CS2002 ?

In ordr to monitor SQL performance you should run sql profiler and monitor
the SQL activity. There can be two things happening
1. Some sql calls are taking more time
2. A lot of calls are being made. This might be an issue with the way the
code is trying to get and render information on your site.

You should also consider using caching on your site so that once a category
page is loaded subsequent access to the page fetch the data from the cache
without hitting the sql server.

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

--------------------
NNTP-Posting-Date: Wed, 17 Aug 2005 19:43:13 -0500
Subject: Catagory pages load slowly
From: kirksmithson@hotmail-dot-com.no-spam.invalid (Smitty200)
Newsgroups: microsoft.public.commerceserver.general
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 8bit
User-Agent: newsSync (Commerce Server) 6668
Message-ID: <mfudnXQIsYs8RJ7eRVn_vQ@giganews.com>
Date: Wed, 17 Aug 2005 19:43:13 -0500
Lines: 1
X-Trace:
sv3-3ClGrBlpF06p02jSwW9L953qQ/dWx2Oq+o1wmby17GjthC1TFv2Dfwi5P/gbTQimIOCNi8oR
wcMwZzp!p159BRV6tpHSHs9bYV6L2mqSaQXG34KqbC+MrvPCbSJPrsgontzy/EfSMFTy
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
X-Postfilter: 1.3.32
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!nntp.giganews.com!border1.nntp.dca.gigan
ews.com!local01.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3232
X-Tomcat-NG: microsoft.public.commerceserver.general

Our catagory pages display 8 items per page and then page numbers at
the top to display the each page of 8 items. When the number of pages
moves above 4-5 for a category the page takes a long time to load. If
there is 4 or less pages load time is acceptable. I am new to
commerce server and have inherited site that was coded off shore.
Should I look at the SQL tables for indexing optimization first? Is
there any suggestions for what i should be looking for.
Any help would be very much appreciated.

Smitty200 · Guest

We are using CS2002.

The code base I am dealing with was written before I got here. I kno
.net but have no experience with Commerce server

Is there a book you could recommend that would help me with th
commerce server side of things

Vinayak Tadas[MSFT] · Guest

I would recommend the CS2002 online help.
I have a blog http://blogs.msdn.com/vinayakt which contains useful
information on catalog system
You need to get familiar with the objects in the
Microsoft.CommerceServer.Runtime.dll
CS2002 also ships a sample Retail2002 site whcih you can use to understand
the commerce server objects
There are also some sample siteltes in the SDK folder that can help you
with the programming model and the various commerce server objects
Finally you can also download the Starter Site whcih you can customize for
your needs. This site will alos help you understand Commerce Server
Incase you get stuck you can post to the newsgroups and someone might be
able to help you
All the best!

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

--------------------
NNTP-Posting-Date: Thu, 18 Aug 2005 11:43:04 -0500
Subject: re:Catagory pages load slowly
From: kirksmithson@hotmail-dot-com.no-spam.invalid (Smitty200)
Newsgroups: microsoft.public.commerceserver.general
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 8bit
User-Agent: newsSync (Commerce Server) 6687
References: <mfudnXQIsYs8RJ7eRVn_vQ@giganews.com>
Message-ID: <W8udnameQfUEJ5neRVn_vQ@giganews.com>
Date: Thu, 18 Aug 2005 11:43:05 -0500
Lines: 1
X-Trace:
sv3-wkZA5CWAGeyY9PZp2v9vFGp/ufH6G3QZmp+9B7hXLmPmbxcptuixXBSkv3HY0h2TjxZ8BgRH
Xct5Ui4!SOfSsgwUDJQxsr/B5ugnyAXKuPEOLd/JfEWC9jGxFuaL20fczj5xdE/NwqmF
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
X-Postfilter: 1.3.32
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!nntp.giganews.com!border1.nntp.dca.gigan
ews.com!local01.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3237
X-Tomcat-NG: microsoft.public.commerceserver.general

We are using CS2002.

The code base I am dealing with was written before I got here. I know
..net but have no experience with Commerce server.

Is there a book you could recommend that would help me with the
commerce server side of things.

Colin Bowern · Guest

Smitty,

I'd recommend picking up DevPartner Community Edition from Compuware or
JetBrains dotTrace Profiler if the application is based on a .NET platform.
They will give you good inside into which call is taking the most time which
you can then use to focus your search further. dotTrace is probably the
least bulky from an install/setup perspective and DevParter is free.

Cheers,
Colin

"Smitty200" <kirksmithson@hotmail-dot-com.no-spam.invalid> wrote in message
news:mfudnXQIsYs8RJ7eRVn_vQ@giganews.com...

	Windows Server Forum Index -> Commerce Server	All times are GMT
Page 1 of 1