넥

FOUND_ROWS()

· 2008-10-08 (수) 19:37:58 · 3882 · 3
FOUND_ROWS() For a SELECT with a LIMIT clause, the number of rows that would be returned were there no LIMIT clause

이걸 쓰면 sql 실행 시간이 확실히 줄 듯합니다.
[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]

댓글 3개

오 신기하네요.~~~

일단 스크랩 해둘게용^^

좋은 정보 감하합니다.
mysql> SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name WHERE id > 100 LIMIT 10;
mysql> SELECT FOUND_ROWS();
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,188건
+
제목 글쓴이 날짜 조회
08-11-26 조회 4,608
08-11-25 조회 3,729
08-11-25 조회 2,920
08-11-25 조회 4,486
08-11-25 조회 4,369
08-11-21 조회 4,357
08-11-21 조회 5,282
08-11-20 조회 3,909
08-11-20 조회 3,720
08-11-19 조회 3,989
08-11-19 조회 4,239
08-11-18 조회 4,014
08-11-15 조회 2,891
08-11-14 조회 3,193
08-11-14 조회 2,856
08-11-14 조회 3,252
08-11-13 조회 3,876
08-11-12 조회 1만
08-11-07 조회 4,559
08-11-07 조회 5,565
08-11-03 조회 3,320
08-11-01 조회 5,025
08-11-01 조회 2,978
08-10-30 조회 2,687
08-10-30 조회 3,622
08-10-30 조회 2,728
08-10-30 조회 2,969
08-10-30 조회 2,827
08-10-29 조회 3,910
08-10-29 조회 2,888
08-10-29 조회 2,415
08-10-20 조회 2,554
08-10-18 조회 4,498
08-10-16 조회 3,551
08-10-16 조회 3,349
08-10-14 조회 2,565
08-10-11 조회 3,857
08-10-11 조회 2,458
08-10-09 조회 2,557
08-10-09 조회 2,720
08-10-09 조회 4,186
08-10-08 조회 3,883
08-10-02 조회 3,822
08-10-02 조회 2,562
08-10-02 조회 2,696
08-09-29 조회 4,638
08-09-29 조회 4,268
08-09-26 조회 5,589
08-09-26 조회 3,557
08-09-26 조회 3,632
08-09-26 조회 2,772
08-09-26 조회 3,812
08-09-26 조회 3,548
08-09-26 조회 4,323
08-09-22 조회 3,880
08-09-22 조회 3,063
08-09-22 조회 4,011
08-09-22 조회 2,975
08-09-22 조회 2,619
08-09-21 조회 3,620
08-09-20 조회 4,199
08-09-20 조회 5,465
08-09-20 조회 4,558
08-09-20 조회 2,876
08-09-20 조회 3,282
08-09-20 조회 3,643
08-09-20 조회 3,013
08-09-20 조회 3,211
08-09-20 조회 4,199
08-09-20 조회 3,694
08-09-20 조회 3,281
08-09-19 조회 5,677
08-09-19 조회 4,462
08-09-19 조회 2,771
08-09-18 조회 5,121
08-09-18 조회 4,189
08-09-18 조회 3,552
08-09-18 조회 2,760
08-09-18 조회 3,669
08-09-18 조회 3,459
08-09-17 조회 3,323
08-09-16 조회 3,272
08-09-10 조회 2,491
08-09-09 조회 3,288
08-09-06 조회 4,200
08-09-06 조회 2,753
08-09-06 조회 3,114
08-09-06 조회 2,784
08-09-06 조회 3,018
08-09-06 조회 2,895
08-09-06 조회 2,864
08-09-05 조회 3,879
08-09-05 조회 3,704
08-09-05 조회 3,522
08-09-05 조회 2,741
08-09-05 조회 3,777
08-09-05 조회 5,736
08-09-05 조회 4,197
08-09-05 조회 3,089
08-09-05 조회 3,232