You are browsing the documentation for version 4.2 of OroCommerce, OroCRM and OroPlatform, which is no longer maintained. Security Support ends in January 2024. Read version 5.0 (the latest LTS version) of the Oro documentation to get the updated information.
See our Release Process documentation for more information on the currently supported and upcoming releases.
ORM Search Engine
OroSearchBundle provides ORM search engine out of the box. It stores index data in DB tables and uses fulltext index to perform search. Bundle supports search index for both MySQL and PostgreSQL DBMS. ORM engine is used by default.
ORM engine configuration is stored in
and does not require any additional engine parameters.
ORM search engine has a straightforward implementation - it simply
stores index data in appropriate tables: separate tables for
integer value, and another table
to store general information. The table that stores text data has
services: oro_search.search.engine: class: Oro\Bundle\SearchBundle\Engine\Orm arguments: - '@doctrine' - '@oro_entity.doctrine_helper' - '@oro_search.mapper' calls: - [setLogQueries, [%oro_search.log_queries%]]
Each supported DBMS has its own driver that knows about specific search implementation and generates valid SQL.
parameters: oro_search.drivers: pdo_mysql: Oro\Bundle\SearchBundle\Engine\Orm\PdoMysql pdo_pgsql: Oro\Bundle\SearchBundle\Engine\Orm\PdoPgsql
Currently, special characters are not supported in the ORM search engines. Every character that is not a unicode letter or a number is replaced with a whitespace before the query.
Another feature of ORM engine is fulltext index processing. Configuration defines fulltext manager Oro\Bundle\SearchBundle\Engine\FulltextIndexManager that is used during installation and inside a special listener - it allows the system to create fulltext indexes bypassing Doctrine processing.
Note for MySQL driver: MySQL has a lower limit to the string length for fulltext index called ft_min_word_len, i.e. if a string is shorter than this limit, the fulltext index will not be used. It is recommended to change this value to 3.