quot;Error Code : 1214
The used table type doesn't support FULLTEXT indexes"
So, what is the deal? Am I missing something?
And if I can't use boolean searches on InnoDB tables with mySQL 5.0.18,
Then WHEN will I be able to?
In the mean time, what is the best way to generate this e
*MySQL Manual - Chapter 12.7.4. Full-Text Restrictions* says: *Full-text
searches are supported for MyISAM tables only. *
You could try to do what i did... with some overhead... I also had InnoDB
tables for an application and also was in a great need of Full-Text
Searches.
I made a mirror MyISAM
Daevid,
- Original Message -
From: ""Daevid Vincent"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 07, 2006 5:54 AM
Subject: RE: Boolean searches on InnoDB tables?
Osku is working on FULLTEXT for InnoDB.
So, despite what th
> Osku is working on FULLTEXT for InnoDB.
So, despite what the documentation says:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html
Which states:
"They can work even without a FULLTEXT index, although a search executed in
this fashion would be quite slow. "
You're saying that InnoDB t
Daevid,
- Original Message -
From: ""Daevid Vincent"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Saturday, March 04, 2006 9:54 AM
Subject: Boolean searches on InnoDB tables?
I just discovered this:
http://dev.mysql.com/doc/refman/5.0/en/f
doesn't support FULLTEXT indexes"
So, what is the deal? Am I missing something?
And if I can't use boolean searches on InnoDB tables with mySQL 5.0.18,
Then WHEN will I be able to?
In the mean time, what is the best way to generate this equivallent
functionality via PHP or some othe
88254
http://www.gunmuse.com
469 228 2183
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, April 08, 2005 11:13 AM
To: Mysql
Subject: Boolean searches
When using the Boolean search capabilities, I am finding it terribly slow.
Since I am sure
When using the
Boolean search capabilities, I am finding it terribly slow. Since I am
sure MySql uses this on their own site. What version of MySql is the
fastest at this 5.0?
I am using the
PHPMySearch and I really think he did fair job on the crawler part. I
built an XML converter f