Any harm in mixing table types?

I have a database with an InnoDB table and a MyISAM table. I will be using
them in JOIN statements. I didn't use two different table on purpose. I
switched to MyISAM for the second table type when I discovered that I had to
use MyISAM to get 'fulltext' search ability.

Is there any harm in having two different table types? Will there be any
performance penalties, restrictions, or other issues?

thx

--

Robert Oschler
"Let the web hear you, add your voice to your web site in minutes!"
-- http://audiodirect.spiderchase.com/
(For a limited time, free voiceover with every sign-up, use this link
instead)
-- http://audio.spiderchase.com/
(A song - are you blue?)
-- http://bluedreams.spiderchase.com/

"Robert Oschler" <no_replies@fake_email_address.invalid> wrote
in message news:<Idr1b.14390$2Y6.4617238@news2.news.adelphia. net>...
>
> I have a database with an InnoDB table and a MyISAM table. I will be using
> them in JOIN statements. I didn't use two different table on purpose. I
> switched to MyISAM for the second table type when I discovered that I had to
> use MyISAM to get 'fulltext' search ability.
>
> Is there any harm in having two different table types? Will there be any
> performance penalties, restrictions, or other issues?

Possibly. Certain features available in one table type may not be available
in the other. For example, you can't do transactions on a MyISAM table.
This said, as long as a feature is not table-type-specific, table type
should make no difference.

Cheers,
NC