This query was pretty fast avg. 1-3 s / search
SELECT m1.id FROM table1 AS t1 JOIN table AS t2 ON m1.textid=m2.id WHERE
match(t2.text) AGAINST('$searchString' IN BOOLEAN MODE);
I also added an index on table1.textid and table2.id.
Is there a way to optimize this query even more?
// Fredrik Car
Hi,
thanks for your answer.
I tried what you suggested:
select table1.id,table1.name from table1,table2 where
table1.textid=table2.id AND match(table2.text)
AGAINST('$searchString' IN BOOLEAN MODE);
But that query takes for ever to run and uses 100% cpu. Is there a
faster way to do this query?
Fredrik Carlsson <[EMAIL PROTECTED]> wrote:
> Hi,
> I have a question regarding to search with fulltext on table and fetch
> the data from another.
>
> Table one:
> id, textid, name, number, url
>
> Table two:
> id, text
>
> On table two there is a fulltext index.
>
> These two tables recentl
