Very slow select query with IN(...)

2003-02-12 Thread Artem Koutchine
Hi! I have posted this message yerstaday, but apperantly did not give enough information for reader to figure out what's going on. So, i am reposting it with more information. I have the following table: create table law_words ( l_id int unsigned not null, w_id int unsigned not null,

Re: Very slow select query with IN(...)

2003-02-12 Thread Rafal Jank
On Wed, 12 Feb 2003 15:50:29 +0300 Artem Koutchine [EMAIL PROTECTED] wrote: Hi! I have posted this message yerstaday, but apperantly did not give enough information for reader to figure out what's going on. So, i am reposting it with more information. I have the following table:

Re: Very slow select query with IN(...)

2003-02-12 Thread Brent Baisley
But you're not using the word search engine, which would be the full text index. I'm not sure what you mean by morphology. MySQL 4 full text searches support a lot of things, including using * as the truncation operator. Aside from that, perhaps it's the speed of your processor that

Re: Very slow select query with IN(...)

2003-02-12 Thread Artem Koutchine
[EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, February 12, 2003 4:57 PM Subject: Re: Very slow select query with IN(...) But you're not using the word search engine, which would be the full text index. I'm not sure what you mean by morphology. MySQL 4 full text searches support a lot

Re: Very slow select query with IN(...)

2003-02-12 Thread Artem Koutchine
On Wed, 12 Feb 2003 15:50:29 +0300 Artem Koutchine [EMAIL PROTECTED] wrote: Hi! I have posted this message yerstaday, but apperantly did not give enough information for reader to figure out what's going on. So, i am reposting it with more information. I have the following table: