PEAK XOOPS - Re: JOINよりIN 
Re: JOINよりIN
| 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... |
Re: JOINよりIN
msg# 1
- depth:
- 0
Previous post
-
Next post
|
Parent
-
No child
|
Posted on 2006/6/4 11:08
minahito
Posts: 10
Posts: 10
Quote:
これができません……;;
JOIN レベルですでにまともに使えない…… orz
こんな構造の場合、SQL書きを得意としている人間は、ついつい
これができません……;;
JOIN レベルですでにまともに使えない…… orz
Votes:0
Average:0.00
Posts tree
-
Re: JOINよりIN
(minahito, 2006/6/4 11:08)
Login