Re: MySQL full text search multiple tables

2003-09-09 Thread Matt W
x27;m not sure that the join is done using the id index. :-( I think a full scan may be done on table2. This is very bad if table2 has a lot of rows. Matt - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, S

Re: MySQL full text search multiple tables

2003-09-09 Thread Victoria Reznichenko
Steve Radabaugh <[EMAIL PROTECTED]> wrote: > > I have been exploring MySQL's full text search feature and have not been > able to find any information on querying a full text search across > multiple tables. Do you have to make recursive queries to each table? You can't create fulltext index on

MySQL full text search multiple tables

2003-09-08 Thread Steve Radabaugh
Greetings, I have been exploring MySQL's full text search feature and have not been able to find any information on querying a full text search across multiple tables. Do you have to make recursive queries to each table? Thank you in advance, Steve Radabaugh -- MySQL General Mailing List For li

Re: Tuning MySQL Full-text Search

2002-11-27 Thread Sinisa Milivojevic
On Wed, 27 Nov 2002 11:53:25 +0200 "Nick Kostirya" <[EMAIL PROTECTED]> wrote: > Hi, All. > > How can I add additional characters (Ukrainian alphabet) to the source > code > for parse? > > Thanks, Nick. > > database,sql,query,table,handler,compile,ChangeSet > > > Just add a charset. Tak

Tuning MySQL Full-text Search

2002-11-27 Thread Nick Kostirya
Hi, All. How can I add additional characters (Ukrainian alphabet) to the source code for parse? Thanks, Nick. database,sql,query,table,handler,compile,ChangeSet - Before posting, please check: http://www.mysql.com/manu

Re: MySQL Full-text search

2002-05-30 Thread Ryan Barber
Thanks Philip, I spent some time looking for that list, but obviously didn't look hard enuf. Ryan > > 2) Why would these sample words have no match? > > Cannot match against "when", "most", "like", "goes" Why are these > > words not in the index? The file contains 1 million title records > > an

Re: MySQL Full-text search

2002-05-30 Thread Philip Mak
On Thu, May 30, 2002 at 08:15:41AM -0700, Ryan Barber wrote: > 2) Why would these sample words have no match? > Cannot match against "when", "most", "like", "goes" Why are these > words not in the index? The file contains 1 million title records > and all of these words are in the file many times.

MySQL Full-text search

2002-05-30 Thread Ryan Barber
Hi, We have two major concerns with the full-text search in MySQL. They appear to be simple problems that can be fixed. We are about to use MySQL in a big way, and we would like to license it, however these problems are a major obstacle that must be fixed (or at least understood). 1) Using the w

mysql Full-text Search indexes

2001-05-12 Thread lists
Can anyone share the experiences with mysql Full-text Search indexes? I have been reading here and there about how slow it can be to create/update a text index. Also, are there any benchmarks on query results on searching such indexes? Christopher Lambrou, CGL Computer Services, Inc