18000 Products, Slow KW Searching

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hello njessen42,
Is 18,000 included sub-products?
Thank you,
uniforms guy

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Uniforms guy Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 15-July-2006 Location: United States Status: Offline Points: 0	Post Options Post Reply Quote Uniforms guy Report Post Thanks(0) Quote Reply Posted: 03-May-2008 at 3:19am
	Hello njessen42, Is 18,000 included sub-products? Thank you, uniforms guy

Matt Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group Joined: 20-July-2006 Location: United States Status: Offline Points: 73	Post Options Post Reply Quote Matt Report Post Thanks(0) Quote Reply Posted: 02-May-2008 at 10:47pm
	Hi Guys, We have added two additional features that will be available in the next update. - Show Top Search Results - AJAX Loading Window while search is searching The “Top” feature has been shown to drastically reduce search times. While the AJAX Window lets the customers know something is working. The features will be optional and they can be turned on or off. Since you have 18,000 products and are currently experiencing problems you may open a ticket and obtain a pre-release of the "new search files".

geoff Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 15-January-2006 Status: Offline Points: 2	Post Options Post Reply Quote geoff Report Post Thanks(0) Quote Reply Posted: 02-May-2008 at 10:06pm
	Yes - I completely agree with the observation. KW searching through the product database once it reaches >2000+ products is really weak compared to alternative indexed searches. I presume the search is proportional to content. So it does not scale well. Hopefully Early Impact will comment on this. I instead switched to using an add-in site search utility - currently Google custom search.

njessen42 Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 12-November-2007 Location: Spokane, WA Status: Offline Points: 0	Post Options Post Reply Quote njessen42 Report Post Thanks(0) Quote Reply Posted: 02-May-2008 at 6:55pm
	We are building a store with PC that has around 18,000 items. When we do generic KW searches it is really slow. For example we sell beads and jewelry findings and a search for bead or crystal sometimes times out. Is there a way to optimize cart searches? We are using a SQL database and our server is also pretty hefty hardware wise. This is happening when only one person is on the site at a time, not even multiple people. Any thoughts?