Target | News |
Subject | IN is faster than JOIN |
Summary | MySQL is one of the fastest Database Engine with simple queries, though it is not so fast on with complex queries.Thus, we should divide queries simple as possible.eg) permission system between categories and groups: CREATE TABLE cat ( `cid` int NO... |
これは、MySQLのJOINの設計がかなり悪いということなんでしょうか。
MySQLがPHPと違うサーバにある場合はちょっと事情が変わりそうですね。