g*****g
发帖数: 34805 | 1 It seems MySql is very low in view queries. Oracle seems to
update view dynamically and the performance is close to table,
but view in MySql just doesn't scale well, any idea of that?
Thanks. | M*****r
发帖数: 1536 | 2 Trace?
【在 g*****g 的大作中提到】
: It seems MySql is very low in view queries. Oracle seems to
: update view dynamically and the performance is close to table,
: but view in MySql just doesn't scale well, any idea of that?
: Thanks.
| I******e
发帖数: 101 | 3 The view optimization is very limited. If there is no one to one
relationship, MySQL will create temp tables. That can kill the query. This
makes the view almost useless. |
|
