Re: Boolean searches on InnoDB tables?

2007-10-24 Thread mos
At 02:54 AM 3/4/2006, Daevid Vincent wrote: I just discovered this: 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. " But then I'm kicked in the nuts because:

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/fulltext-boolean.html Which