ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Customizing ProductCart
  New Posts New Posts RSS Feed - 18000 Products, Slow KW Searching
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

18000 Products, Slow KW Searching
 Post Reply Post Reply Page  12>
Author
Message Reverse Sort Order
  Topic Search Topic Search  Topic Options Topic Options
Matt View Drop Down
Moderator Group
Moderator Group


Joined: 20-July-2006
Location: United States
Status: Offline
Points: 73 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Matt Quote  Post ReplyReply Direct Link To This Post Topic: 18000 Products, Slow KW Searching
    Posted: 05-June-2008 at 1:26pm
Ok. Here is the link to the instructions for adding the AJAX pop-up to the small search box.

http://wiki.earlyimpact.com/how_to/ajax_small_search_box



Edited by Matt - 05-June-2008 at 1:45pm
Back to Top
Espressotec View Drop Down
Groupie
Groupie


Joined: 10-August-2007
Location: Canada
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Espressotec Quote  Post ReplyReply Direct Link To This Post Posted: 04-June-2008 at 6:23pm
http://wiki.earlyimpact.com/
The link is also in the top right hand side of the Product Cart Forum Header
Espressotec Sales and Services
Back to Top
nathan View Drop Down
Newbie
Newbie


Joined: 20-April-2007
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote nathan Quote  Post ReplyReply Direct Link To This Post Posted: 03-June-2008 at 4:23pm
Can you post a link to wiki? Thanks!
Back to Top
Matt View Drop Down
Moderator Group
Moderator Group


Joined: 20-July-2006
Location: United States
Status: Offline
Points: 73 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Matt Quote  Post ReplyReply Direct Link To This Post Posted: 03-June-2008 at 12:21am

The "Searching..." pop-up will work with the small search.  However, it requires changes to a file that is frequently customized by stores.  So we did not include it with the beta release.  However, I would be happy to provide more information.  I'll post the details on the Wiki and get back to you shortly.
Back to Top
Hamish View Drop Down
Admin Group
Admin Group


Joined: 12-October-2006
Location: United Kingdom
Status: Offline
Points: 56 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Hamish Quote  Post ReplyReply Direct Link To This Post Posted: 02-June-2008 at 11:47pm
Hi Nathan,
     Take a look at : www.earlyimpact.com/forum/forum_posts.asp?TID=1621&PN=1

njessen42 & I have been discussing how to drop the details field from the search.
Of course this was against the EXISTING version of the search - not the patched version, so tread carefully!  

Can you provide a link to your site?

Edited by Hamish - 02-June-2008 at 11:48pm
Editing ProductCart Code?

See WIKI Guidelines for Editing ProductCart's ASP Source Code
Back to Top
nathan View Drop Down
Newbie
Newbie


Joined: 20-April-2007
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote nathan Quote  Post ReplyReply Direct Link To This Post Posted: 02-June-2008 at 9:39pm
Originally posted by Matt Matt wrote:

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".




 
Is the AJAX Loading Window suppose to kick in from smallsearchbox queries also?
Back to Top
nathan View Drop Down
Newbie
Newbie


Joined: 20-April-2007
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote nathan Quote  Post ReplyReply Direct Link To This Post Posted: 02-June-2008 at 9:34pm
I applied the patch today and it cut my kw search from 50 to 25 sec... Big improvement, but still needs work... We have over 9,000 SKU's with extremely long descriptions. Is it possible to only do a kw search on titles? I believe pc searches descriptions and this is most likely our problem.
Back to Top
njessen42 View Drop Down
Groupie
Groupie
Avatar

Joined: 12-November-2007
Location: Spokane, WA
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote njessen42 Quote  Post ReplyReply Direct Link To This Post Posted: 12-May-2008 at 1:34pm
Matt thanks for the suggestion. We sent a help ticket to Early Impact, they sent us the new patch and our search runs fantastic. With 18,000 beads and findings, a generic search for just "Bead" worked in under 4 seconds, before it would time out and that was with a SQL database and some major hardware. Thanks again. When we get the site up on July 1st, I will post the link for everyone to see. Product Cart rocks!!
Back to Top
geoff View Drop Down
Newbie
Newbie


Joined: 15-January-2006
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote geoff Quote  Post ReplyReply Direct Link To This Post Posted: 05-May-2008 at 8:03pm
It works well for my data of 5000 products and 15MByte database. It takes a little configuration - like everything but once set up you can forget it.
Back to Top
njessen42 View Drop Down
Groupie
Groupie
Avatar

Joined: 12-November-2007
Location: Spokane, WA
Status: Offline
Points: 0 		Post Options Post Options   Thanks (0) Thanks(0)   Quote njessen42 Quote  Post ReplyReply Direct Link To This Post Posted: 05-May-2008 at 11:45am
There are no sub-products. There are 18,000 individual items for sale.

Thanks for the info above. Does the Google custom search work pretty well? 
Back to Top
 Post Reply Post Reply Page  12>
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.063 seconds.