Selecting a specific number of records from a large set is a good idea, but when the set is really large, the effect of degradation of the idea arises. Selecting several records from a certain position creates a real performance drop: before reaching the goal, MySQL looks at other records, spending time on it.
Formally, the MySQL limit can work from the beginning of the table or from its end. A sample can determine a specific number of records and begin at a given position. A case can always arise, that is, the onset of a worse situation is possible. Usually the general flow of customers determines the general statistical mode of operation, but it is necessary to foresee different situations, this is a serious decision in favor of the site.
LIMIT Construction Syntax
MySQL limit syntax , , select delete.
(select) : "O" "R", (delete) - "R".
limit "O, R"
MySQL limit: . : "O" - , "R" - . , "O" = 9000, MySQL 9001 , 9000. "R" = 1000, « » 10000 .
MySQL select limit , asc / desc. , .
, "R" : MySQL delete limit. . (where) .
, AJAX . delete.
where "limit 1" MySQL . - . (, , , ).
- , MySQL limit O, R , .
, , .
.
MySQL
MySQL - . SQL . , .
. , , , .
, MySQL (limit - ) , , .
- , 80- . , , , , http- .
Apache MySQL , - MySQL.
, . . . , , .
, , . - .
: - , . , , , , .
? - , , (, ). MySQL query limit "big_info" c 100000 24 .
100024 - . "big_info" "big_info[0...999]" 1000 , MySQL "order by * limit O, R", .
, , , . MySQL .
: , , - . "": , , .
«» - «»: -. «» . , - -: . ...
, , : .
, . MySQL limit . . MySQL limit - .
, . . - .
: « » .
- . , .
, .
, , , - , .
, : . , , « » - Oracle. Oracle SQL- . MySQL .
MySQL limit .
, , , Oracle. . Oracle , .
. - , . . , - , .
- .
. . , - , .
, . , , .
, , . - , .
, .
: - , . (MySQL limit) , (MySQL order by, group by, join & where) , , , , « ».
SQL is a good language, but if you add associations to it, it will become even better.