剛剛在弄 Cyrus,Backend Database 用 MySQL 5.0.0,在設定 table 時我突然想到應該將 table 拆散,用 CREATE VIEW 及 JOIN 建立一個大的 table,一方面是彈性問題,一方面是 performance 著想。
結果剛剛才在 C.1.2 Changes in release 5.0.1 (27 Jul 2004) 看到:
Added support for read-only and updatable views based on a single table or other updatable views. View use requires that you upgrade your grant tables to add the view-related privileges. See section 2.5.8 Upgrading the Grant Tables.
目前只有支援 single table… 看起來我要的功能還要等很久呢 :p