MySQL equivalent of Oracle "instead of" trigger for insert, delete and update on view

[harry sheng]

Hi,

I am evaluating the possibility of migrating data from Oracle8 database to MySQL.
I am complete new to MySQL. When looking at MySQL, the following questions pop up:

1. MySQL view access performance
In Oracle, quite a few views are created to provide data to business objects.
Recreating the database schema is out of the question. I'll have to copy the
table structure and views from Oracle to MySQL.

But most of these views join about 10 tables. Some of them join up to 14 tables.
Two or three of the joined tables may have millions records. My concern is,
how would these views perform in MySQL.

2. Oracle "Instead of" trigger on view equivalent
"Instead of" trigger is used to insert, delete or update on views.
Does MySQL have Oracle "Instead of" trigger equivalent?

Thanks
Harry Sheng