View Single Post
  #11  
Old 06-12-2007, 06:04 PM
  wjbrewer's Avatar 
wjbrewer wjbrewer is offline
Banned
 

X-Adept
  
Join Date: Feb 2005
Location: Pittsburgh, PA
Posts: 504
 

Default Re: Smart Search from alteredCart :: Spell Checking, Did You Mean? and More.

Quote:
Originally Posted by anandat
Has any one use this on site which have more than 5000 products ?

The Smart Search was tested on stores with over 5,000 products and over 10,000 unique words and most searches take less than 1 second to return. As with any program if your site is sluggish, the search is going to be sluggish. If basic MySQL page take 5-10 seconds to load on your site the Smart Search is going to take 5-10 seconds to complete a search.

Quote:
Originally Posted by anandat
how was the results ? accuracy & time taken for indexing ? Also it's putting high load on server while indexing & searching ?

The results are generated based on their relevancy. For example, if you search for 'shoe', the more often the word shoe is in the title and description of a product the closer it is to the top of the results.

The indexing is a moderately intensive process. It is important to remember because of the index the search is faster because the CPU and SQL intensive functions/queries only need to be run once for each search word. It takes about 1 minute per 1,000 words to build the search database.

The Smart Search is highly configurable with settings to control how complex the searches will be depending on your server. If you are on a slow server you can turn the spell check/suggest accuracy to 'Medium', or 'Low' to speed up your searches. Also, individual portions of the search can be turned on or off to reduce the MySQL and CPU cycles if they are not needed.
Reply With Quote