리자

그누보드4 LIMIT 와 OFFSET 최적화하기 메모

· 2011-08-31 (수) 20:12:21 · 2813
select wr_id, wr_subject from g4_write_cm_free inner join (select wr_id from g4_write_cm_free where wr_is_comment = 0 order by wr_num, wr_reply limit 70000, 100) as wtbl using (wr_id);<div class='small'>[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]</div>
|
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,188건
+
제목 글쓴이 날짜 조회
11-09-19 조회 2,520
11-09-19 조회 2,437
11-09-19 조회 5,439
11-09-19 조회 6,106
11-09-16 조회 2,830
11-09-16 조회 3,072
11-09-16 조회 6,266
11-09-15 조회 3,052
11-09-15 조회 2,810
11-09-15 조회 2,487
11-09-15 조회 2,492
11-09-15 조회 2,690
11-09-15 조회 2,656
11-09-15 조회 2,780
11-09-14 조회 2,695
11-09-14 조회 3,250
11-09-14 조회 2,359
11-09-14 조회 2,291
11-09-14 조회 2,277
11-09-13 조회 2,456
11-09-10 조회 2,925
11-09-10 조회 2,551
11-09-09 조회 3,123
11-09-09 조회 2,987
11-09-09 조회 3,055
11-09-09 조회 3,094
11-09-08 조회 3,781
11-09-08 조회 4,980
11-09-08 조회 3,375
11-09-08 조회 4,304
11-09-08 조회 3,803
11-09-08 조회 3,604
11-09-08 조회 2,713
11-09-08 조회 2,280
11-09-08 조회 2,681
11-09-08 조회 2,795
11-09-07 조회 3,465
11-09-07 조회 3,534
11-09-07 조회 2,962
11-09-07 조회 2,656
11-09-07 조회 2,757
11-09-07 조회 2,780
11-09-07 조회 3,005
11-09-07 조회 2,279
11-09-07 조회 2,384
11-09-07 조회 2,538
11-09-07 조회 3,470
11-09-07 조회 2,753
11-09-06 조회 2,586
11-09-06 조회 2,866
11-09-06 조회 2,428
11-09-05 조회 2,639
11-09-05 조회 2,572
11-09-05 조회 2,857
11-09-05 조회 2,369
11-09-04 조회 2,336
11-09-04 조회 2,304
11-09-03 조회 2,479
11-09-03 조회 2,634
11-09-02 조회 3,365
11-09-02 조회 2,747
11-09-02 조회 2,612
11-09-02 조회 3,522
11-09-02 조회 2,557
11-09-02 조회 2,429
11-09-02 조회 2,439
11-09-01 조회 2,638
11-09-01 조회 2,785
11-09-01 조회 2,667
11-09-01 조회 2,657
11-09-01 조회 2,804
11-09-01 조회 2,660
11-09-01 조회 4,093
11-09-01 조회 3,688
11-09-01 조회 4,342
11-08-31 조회 2,228
11-08-31 조회 2,521
11-08-31 조회 2,814
11-08-31 조회 2,532
11-08-31 조회 2,391
11-08-31 조회 3,180
11-08-30 조회 2,945
11-08-30 조회 4,121
11-08-29 조회 2,949
11-08-29 조회 2,536
11-08-29 조회 5,148
11-08-29 조회 3,279
11-08-29 조회 2,674
11-08-29 조회 3,030
11-08-28 조회 2,434
11-08-28 조회 3,580
11-08-28 조회 2,529
11-08-28 조회 2,904
11-08-26 조회 2,433
11-08-26 조회 2,946
11-08-26 조회 3,188
11-08-26 조회 2,696
11-08-25 조회 2,528
11-08-25 조회 2,845
11-08-25 조회 2,574