Yeah, that is exactly what I wanted to do until I found you can't use it
in InnoDB. I think the suggestion of writing two separate tables is
going to be out of the question because I'm dealing with what could
possibly be a massive amount of records. I shall continue looking at my
options and see what I can come up with.
Thanks!
- Brian
edward potter wrote:
may be a tip or 2 here, this is a new one for me: AGAINST
"How-to: Full text search in MySQL"
http://www.knowbies.com/vladimir-cvetic/databases/mysql/fulltext-search-mysql/
On 11/30/06, Cliff Hirsch <[EMAIL PROTECTED]> wrote:
Why not just use two tables -- one InnoDB and one MyISAM -- and
write/update/delete both tables simultaneously? Twice the performance
hit, but it seems like a viable solution.
the Blog: http://www.utopiaparkway.com
the Karma: http://www.coderswithconscience.com
the Projects: http://flickr.com/photos/[EMAIL PROTECTED]/
the Store: http://astore.amazon.com/httpwwwutopic-20
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
