|
Home > Archive > Commerce Server General > April 2004 > Timeout expired on customer order history
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 |
Timeout expired on customer order history
|
|
| Martin 2004-04-06, 6:34 am |
| We've got a site with about 60'000 users that's been running for about
a year and a half now. Running MSCS 2000.
I'm seeing fairly regular 'Timeout Expired' errors for customers on
their order history pages.
The strange thing is there doesn't seem to be any correlation between
the amount of orders in their history. Some customers have many more
items, yet the page comes back straight away. Yet for others with
less items the database connection times out.
If I run the query from Query analyser, I don't get the Timeouts, but
it does take /much/ longer to run for some customers than others, i.e
minutes instead of seconds.
Any one have any suggestions? I don't want to increse the timeout,
and the rest of the site runs fine, even with a few hundred active
users.
Should I maybe try re-indexing the order table? Or update statistics?
Any ideas appreciated.
Martin
| |
| Caesar Samsi[MSFT] 2004-04-18, 10:52 am |
| Hi Martin, you are one step closer to finding the issue.
Since you already see the longer query time using Query Analyzer, you can
also see the optimizer execution plan of the statement. Check to see if
there are table scans as part of the plan. If so, that may be the culprit
and you may be able to improve performance by using an index.
Note that sometimes the query optimizer will simply do a table scan of small
lookup tables even though there is an index for it, this is likely not a
source of performance issues.
Check to see if table scans are being run for tables with a large amount of
records in them.
Thanks, Caesar.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2004 Microsoft Corporation. All rights
reserved. Use of included script samples are subject to the terms specified
at http://www.microsoft.com/info/cpyright.htm
"Martin" <bigmarts@hotmail.com> wrote in message
news:f2af5fb4.0404060219.bd2bac@posting.google.com...
> We've got a site with about 60'000 users that's been running for about
> a year and a half now. Running MSCS 2000.
>
> I'm seeing fairly regular 'Timeout Expired' errors for customers on
> their order history pages.
>
> The strange thing is there doesn't seem to be any correlation between
> the amount of orders in their history. Some customers have many more
> items, yet the page comes back straight away. Yet for others with
> less items the database connection times out.
>
> If I run the query from Query analyser, I don't get the Timeouts, but
> it does take /much/ longer to run for some customers than others, i.e
> minutes instead of seconds.
>
> Any one have any suggestions? I don't want to increse the timeout,
> and the rest of the site runs fine, even with a few hundred active
> users.
>
> Should I maybe try re-indexing the order table? Or update statistics?
>
> Any ideas appreciated.
>
> Martin
|
|
|
|
|