Answer the question
In order to leave comments, you need to log in
Why are MATCHs slower than regular filters?
There is a big rt index. Here is a rough config example:
index sph_rt
{
rt_attr_uint = id_group
rt_field = f_id_group
rt_attr_uint = date
rt_mem_limit = 512M
docinfo = extern
morphology = none
type = rt
}
SELECT count(*) FROM sph_rt WHERE (MATCH('@f_id_group 9')) GROUP BY `date` LIMIT 400;
runs 3 (!!!) times slower than this query:SELECT count(*) FROM sph_rt WHERE id_group = 9 GROUP BY `date` LIMIT 400;
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question