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
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
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
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
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
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
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.
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
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