Re: Boolean searches on InnoDB tables?

2007-10-24 Thread mos
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

Re: Boolean searches on InnoDB tables?

2006-03-07 Thread Gabriel PREDA
*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

Re: Boolean searches on InnoDB tables?

2006-03-06 Thread Heikki Tuuri
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

RE: Boolean searches on InnoDB tables?

2006-03-06 Thread Daevid Vincent
> 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

Re: Boolean searches on InnoDB tables?

2006-03-05 Thread Heikki Tuuri
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

Boolean searches on InnoDB tables?

2006-03-03 Thread Daevid Vincent
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

RE: Boolean searches

2005-04-08 Thread gunmuse
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

Boolean searches

2005-04-08 Thread gunmuse
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