Search taking much too long

General ShopSite user discussion

Search taking much too long

Postby rmruda » Tue Aug 07, 2007 8:11 pm

Our database is large with approximately 20,000 pages/products. I would say 85% of the time a simple search takes forever (over a minute) and clearly we are loosing customers because of this. We are on a shared server but our ISP says the server is not over utilized. Even if the index file is large (which it must be) a minute to search it and produce a result is unacceptable. Our ISP suggests we first drop a message on the support forum first.
Thanks

Richard
rmruda
 
Posts: 5
Joined: Tue Aug 07, 2007 7:54 pm

Postby ShopSite David » Fri Aug 10, 2007 12:23 pm

I would try having search index less text by going to Preferences -> Search Settings -> Search Indexing and then uncheck the indexing of everything but Name, then Publish and see if this improves things. If the results still take too long I would guess that it is a factor of the load on the shared server. Also that fact that it sounds like the same search sometimes is much faster indicates that the server may be very busy the other times.
-David H.
ShopSite, Inc.
http://www.shopsite.com
ShopSite David
Site Admin
 
Posts: 317
Joined: Fri Aug 04, 2006 1:30 pm
Location: Utah

Postby rmruda » Fri Aug 10, 2007 1:36 pm

ok thanks, makes sense.
R
rmruda
 
Posts: 5
Joined: Tue Aug 07, 2007 7:54 pm


Return to User Forum

Who is online

Users browsing this forum: No registered users and 81 guests