BV Commerce Forum
»
BV Commerce Support
»
General Support
»
How to speed the order searching from order manager keywords ?
Rank: Member
Joined: 4/5/2007(UTC)
Posts: 22
|
Dear Support and Guys,
I recently found it is very slow to search a order using keyword in our order manager. For example, type a ordernumber or email, it takes a long time to get the results. I tried to use sql server tool such as profiler/advisor to improve it, but it can't be improve it any more. Can you give some other way/solution to figure out where it is the problem. Thanks a lot.
Have a good day!
Kevin
|
|
|
|
|
|
Rank: Member
Joined: 2/21/2007(UTC)
Posts: 1,113
|
What is "very slow"? I type in a similar search, such as order number, and the results comes up in about 7 seconds. I'm not sure if it depends on how many orders are in the DB -- ours has about 3000. |
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Kevin,
SP3 introduced a much more optimized search procedure for text fields. Are you running SP3 + hot fixes or SP2?
|
|
|
|
|
|
Rank: Member
Joined: 4/5/2007(UTC)
Posts: 22
|
Joe, Marcus,
We have over 40000 orders, it takes 20-25s to get the results. do you think it is normal?
Kevin
|
|
|
|
|
|
Rank: Member
Joined: 4/5/2007(UTC)
Posts: 22
|
Hi Marcus,
I tried to apply to use sp3, the results is the same, no any improved for the searching time.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.