View Single Post
Old 06-11-2013, 08:20 AM
  ADDISON's Avatar 

Join Date: Jan 2008
Posts: 2,613

Default Re: Consider further search optimization, hesitate between MySQL LIKE and ▒FULL-TEXT▓

I read many times this thread and I have to agree it is very hard to take a decision. It's like looking at an apple, you see its color green or red, but you don't know how the taste could be without a bite. In this moment we would like to bite, but in this case some work from your side is needed. Do you think it worth moving a few steps forward? This is the main question.

Before voting, I would like to read some technical posts, understanding more in detail the situation, beyond the pros/cons comparison.
X-Cart Next: Business 5.2 (learning and testing)
X-Cart Classic: Gold and Gold Plus 4.7
Lots of Modules and Customizations
OS in use: Red Hat Enterprise, Fedora, CentOS, Debian, Ubuntu, Linux Mint, Kali Linux
Ideas for Server configuration (basicaly): Nginx/Pound (reverse proxy), Apache/Nginx (webserver), Squid/Varnish (cache server), HHVM or (PHP-FPM + PHP 5.6 + opcache), MariaDB/Percona MySQL Server, Redis (storing sessions)

You can catch my ideas here:
Reply With Quote