Rank: Member
Joined: 3/10/2008(UTC)
Posts: 13
|
Hi, I have a question about what optimizations can be made to the database (such as adding indexes) to make a product search run faster. I have a store with about 18K products and the product search is pretty slow. We have separate web and database servers in the same rack and both are pretty tricked out so I don't think that is the problem. Any help would be appreciated.
Mark
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Mark,
What version are you running? Version 5.4 which is now available includes an updated search stored procedure that is much faster.
|
|
|
|
|
|
Rank: Member
Joined: 3/10/2008(UTC)
Posts: 13
|
This particular store has 5 SP3. Ill try upgrading and see if it changes anything.
Mark
|
|
|
|
|
|
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.