logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error
Results low by using Search. Anyway to do 're-indexing'? - Results were coming low when doing "Search"
Options
Go to last post Go to first unread
Previous Topic Next Topic
speedythinker1832579  
#1 Posted : Saturday, August 31, 2019 5:53:26 PM(UTC)
speedythinker1832579

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 5/20/2019(UTC)
Posts: 54

Thanks: 1 times
On V7, we were able to do re-index on the database so that using search may get better result. But I couldn't find that feature on V9.

BTW, what is advantage to use one over the other: SQL vs. Full Text

Thanks
Marco
Back to top

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.
Back to top  
mazhar  
#2 Posted : Monday, September 2, 2019 5:45:10 AM(UTC)
mazhar

Rank: Administration

Groups: Admin, Administrators, HelpDesk, System, Authorized User, Developers, Registered
Joined: 10/5/2018(UTC)
Posts: 175

Thanks: 8 times
Was thanked: 17 time(s) in 15 post(s)
AbleCommerce 9 now only support SQL Server Based Full-Text Search and that is managed by the database itself. Gold has a Lucene based Full-Text search too where indexes were maintained separately. Now when you switch over to SQL Full-Text Search under store setting it automatically starts the indexing and there is no separate page for reindexing.

Full-Text Search is more efficient than normal SQL Like based searched because of it happening over-indexed data. Performance may not be noticeable on small databases though. Full-text indexing also allows things like weighting, automatically matching results that may be similar to what you are searching. You can read more about over Stackoverflow
Back to top
judy at Web2Market  
#3 Posted : Wednesday, September 4, 2019 7:48:18 AM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 289

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
Why did you drop SQL and Lucene search? We have one large merchant who is wanting to upgrade, but he uses Sql Search because he gets better results. Some of our clients use Lucene search to get better results.
Back to top
mazhar  
#4 Posted : Wednesday, September 4, 2019 9:19:39 AM(UTC)
mazhar

Rank: Administration

Groups: Admin, Administrators, HelpDesk, System, Authorized User, Developers, Registered
Joined: 10/5/2018(UTC)
Posts: 175

Thanks: 8 times
Was thanked: 17 time(s) in 15 post(s)
Actually what I meant to say was that we removed only Lucene search provider. Standard SQL and SQL Full Text Search providers are both available in AC9, we only removed Lucene.
Back to top
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET 2.2.4.14 | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.149 seconds.