Comments for News of this site(Moderator:Administrator)
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... |
hits 2 items | Replies | Views | Votes | Average | First post | Latest post | |
---|---|---|---|---|---|---|---|
Re: JOINよりIN | 1 | 12342 | 0 | 0.00 | 2006/6/4 21:05 tohokuaiki | 2006/6/5 5:36 GIJOE | |
Re: JOINよりIN | 0 | 8121 | 0 | 0.00 | 2006/6/4 11:08 minahito |