Есть запрос
| Код |
SELECT DISTINCT company.* FROM (company ,company_catalog_list,catalog)
WHERE (company_catalog_list.id_company=company.id_company AND catalog.id_catalog=company_catalog_list.id_catalog AND MATCH (name_catalog)
AGAINST ('ХХХ*' IN BOOLEAN MODE) )
OR MATCH (name_company,name_company2, lname_company,brand_company)
AGAINST ('ХХХ*' IN BOOLEAN MODE) ";
|
но выполняться даже на маленькой оч. медленно 1.2с.
Подскажите как оптимизировать запрос, ожидается большая таблица с данными
Таблица
| Код |
CREATE TABLE `company` (
`id_company` int(11) NOT NULL auto_increment,
`id_user` int(11) default NULL,
`id_global_form_company` int(11) default NULL,
`id_community` int(11) default NULL,
`name_company` char(255) default NULL,
`name_company2` char(255) default NULL,
`lname_company` char(255) default NULL,
`brand_company` char(111) default NULL,
`fname_company2` char(111) default NULL,
...
PRIMARY KEY (`id_company`),
KEY `companyid_global_form_company` (`id_global_form_company`),
KEY `id_community` (`id_community`),
KEY `id_company` (`id_company`),
KEY `id_global_city` (`id_global_city`),
KEY `id_user` (`id_user`),
KEY `num_person_company` (`num_person_company`),
FULLTEXT KEY `name_company` (`name_company`,`name_company2`,`lname_company`,`brand_company`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
|
)