리자

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

· 2011-08-31 (수) 20:12:21 · 2803
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,509
11-09-19 조회 2,424
11-09-19 조회 5,423
11-09-19 조회 6,096
11-09-16 조회 2,815
11-09-16 조회 3,061
11-09-16 조회 6,253
11-09-15 조회 3,036
11-09-15 조회 2,801
11-09-15 조회 2,480
11-09-15 조회 2,481
11-09-15 조회 2,679
11-09-15 조회 2,646
11-09-15 조회 2,774
11-09-14 조회 2,686
11-09-14 조회 3,242
11-09-14 조회 2,350
11-09-14 조회 2,282
11-09-14 조회 2,273
11-09-13 조회 2,449
11-09-10 조회 2,917
11-09-10 조회 2,548
11-09-09 조회 3,116
11-09-09 조회 2,976
11-09-09 조회 3,047
11-09-09 조회 3,084
11-09-08 조회 3,773
11-09-08 조회 4,966
11-09-08 조회 3,361
11-09-08 조회 4,290
11-09-08 조회 3,789
11-09-08 조회 3,597
11-09-08 조회 2,692
11-09-08 조회 2,267
11-09-08 조회 2,668
11-09-08 조회 2,784
11-09-07 조회 3,453
11-09-07 조회 3,526
11-09-07 조회 2,952
11-09-07 조회 2,647
11-09-07 조회 2,747
11-09-07 조회 2,775
11-09-07 조회 3,000
11-09-07 조회 2,274
11-09-07 조회 2,374
11-09-07 조회 2,534
11-09-07 조회 3,466
11-09-07 조회 2,747
11-09-06 조회 2,577
11-09-06 조회 2,859
11-09-06 조회 2,421
11-09-05 조회 2,634
11-09-05 조회 2,564
11-09-05 조회 2,844
11-09-05 조회 2,363
11-09-04 조회 2,326
11-09-04 조회 2,296
11-09-03 조회 2,466
11-09-03 조회 2,629
11-09-02 조회 3,352
11-09-02 조회 2,732
11-09-02 조회 2,604
11-09-02 조회 3,508
11-09-02 조회 2,552
11-09-02 조회 2,419
11-09-02 조회 2,429
11-09-01 조회 2,626
11-09-01 조회 2,776
11-09-01 조회 2,656
11-09-01 조회 2,654
11-09-01 조회 2,789
11-09-01 조회 2,644
11-09-01 조회 4,081
11-09-01 조회 3,675
11-09-01 조회 4,332
11-08-31 조회 2,213
11-08-31 조회 2,502
11-08-31 조회 2,804
11-08-31 조회 2,517
11-08-31 조회 2,376
11-08-31 조회 3,166
11-08-30 조회 2,936
11-08-30 조회 4,053
11-08-29 조회 2,941
11-08-29 조회 2,527
11-08-29 조회 5,139
11-08-29 조회 3,270
11-08-29 조회 2,664
11-08-29 조회 3,012
11-08-28 조회 2,418
11-08-28 조회 3,568
11-08-28 조회 2,522
11-08-28 조회 2,887
11-08-26 조회 2,422
11-08-26 조회 2,935
11-08-26 조회 3,180
11-08-26 조회 2,680
11-08-25 조회 2,517
11-08-25 조회 2,834
11-08-25 조회 2,562