What engine is the best ?

[siliconmike]

We have developed a site where users can post blogs.

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

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 ?)

Mike

[Ray in HK]

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.

"siliconmik e" <siliconmike@ya hoo.com> ¦b¶l¥ó
news:1120545908 .906222.276280@ g43g2000cwa.goo glegroups.com ¤¤¼¶¼g...[color=blue]
> We have developed a site where users can post blogs.
>
> Now, each blog is stored in a separate row, in a table called
> blog_table.
>
> 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 ?)
>
> Mike
>[/color]