Enhanced Searches

If you have modifications for the Enuuk Auction Platform which you can sell to other users, list details here.
Post Reply
RWAP
Site Admin
Posts: 750
Joined: Fri Jan 08, 2010 2:23 am
Location: Stoke-on-Trent
Contact:

Enhanced Searches

Post by RWAP » Wed Apr 28, 2010 7:16 am

We have written an improved search function for Enuuk.

On the search page, you can now select whether you wish to search for
a) any of the keywords
b) all of the keywords
c) the exact phrase

The filter for search types is now more sensible, and lists just:

- Fixed Price Items
- Standard Auctions
- Scheduled Auctions
- Penny Auctions (if enabled)
- Reverse Auctions (if enabled)

Fixed price items lets a user search quickly when they want to purchase one item now rather than waiting until an auction finishes to see if they have been the highest bidder. This therefore returns matching searches in either Fixed Price Auctions, Lot Auctions, or where a standard auction has a Buy It Now price available.

Scheduled Auctions lets users find out what is coming up on the site and mark them as a favourite auction for future reference.

Cost £75
Available from: http://www.rwapservices.co.uk/enuuk_modules.html

RWAP
Site Admin
Posts: 750
Joined: Fri Jan 08, 2010 2:23 am
Location: Stoke-on-Trent
Contact:

Re: Enhanced Searches

Post by RWAP » Sat Aug 14, 2010 6:50 pm

We have now released v1.2 of this module, which features a more natural search, returning more of the items which match your search query towards the top of the results.

Try out the search feature on www.sellmyretro.com to see for yourself

RWAP
Site Admin
Posts: 750
Joined: Fri Jan 08, 2010 2:23 am
Location: Stoke-on-Trent
Contact:

Re: Enhanced Searches

Post by RWAP » Thu Aug 27, 2015 7:32 pm

We are in the midst of testing an updated version of the Enhanced Search module, which creates a cache of search results to vastly improve the speed of the searches.

We are open to ideas / comments on how this would be best optimised.

At the moment, we cache the results based on all of the possible search parameters, so that if the same set of parameters are used again, then the resulting list of offer ids is already known so we only need to test if those offers are still active.

The cache has to be cleared every time that a new listing is activated unfortunately, in order to ensure that the new listing appears in the search results.

However, what we do is to start re-building the index, using a cron job based on the most popular searches so that the most common searches are cached as soon as possible.

Any more suggestions?

RWAP
Site Admin
Posts: 750
Joined: Fri Jan 08, 2010 2:23 am
Location: Stoke-on-Trent
Contact:

Re: Enhanced Searches

Post by RWAP » Wed Sep 02, 2015 9:49 am

Actually we have decided on a new approach to searches - we have re-engineered the search routines to use MySQL's Fulltext searches.

Unfortunately, these are only available under MySQL v5.6 or later for InnoDB (the SQL engine which is used by Enuuk).
We have therefore implemented a secondary mirror table which uses the MyISAM SQL engine which has fulltext indexing.

The results are very quick search results and a vast reduction in the amount of memory used by a site running Enuuk (one site saw a reduction from around 8GB RAM to less than 5GB).

The only downside is that you may have to do some fine tuning - for example, for our test site, we had to change the MySQL setting to index 3 character words (it defaults to 4 characters) and add a list of 2 character words / identifiers which are common to the items listed on the site.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest