oc_t_item_description is MyISAM ?

[Aficionado]

I see than while everything else in my db is innoDB, oc_t_item_description is MyISAM.

Any ideas why that happens and what it means ? And should i switch it also to innoDB ?

Thanks

[marius-ciclistu]

I don't have any idea but maybe this could help https://stackoverflow.com/questions/12614541/whats-the-difference-between-myisam-and-innodb

[Aficionado]

Yes, thanks. I know the difference. The question is why ONE only table is MyISAM ?

Should be like that ?

[marius-ciclistu]

In my case is the same as you described it. Only this is MyISAM.

Maybe because the description is "the biggest" so this type is smaller in size...

[teseo]

Hi,

Code: [Select]

MYISAM supports fulltext search
It's a table originally built to optimize searches to a maximum. (Until MySQL 5.6 only MyISAM supported FULLTEXT).

Regards

[Aficionado]

Ok, got it. Nothing wrong i guess, i was a bit worried.

Thanks !