What engine is the best ?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
We have developed a site where users can post blogs.

Now, each blog is stored in a separate row, in a table called

This single table would be the most active one and would grow to large
size in the coming years.

What is the most advisable engine for this table - Innodb or MyISAM ?

Also, I do need FULLTEXT search, and since Innodb doesn't support
FULLTEXT indexes, are there 3rd party tools that could do the indexing
? (Maybe mnoGoSearch ?)


Re: What engine is the best ?

as I know, fulltext search in Oracle or MS-SQL is pre-compiling a list of
searhing words, it's just a bit better than table scanning.

Quoted text here. Click to load it

Site Timeline