4 ms·
How about any cases where you don't want to transfer all the rows you're skipping over the wire? As in, nearly all cases?
by kogir 14y ago
How about any cases where you don't want to transfer all the rows you're skipping over the wire? As in, nearly all cases?
- corresation 14y agoYou wouldn't be "skipping" those rows because they would be transferred once. The database is almost always the most constrained part of a solution, and the various hack pagination techniques are almost always (not 100%. More like 98%) a naive mistake.
- anko 14y agoI am really interested in this argument, because I am currently converting a mysql based web search to use apache solr. I have been thinking about all the arguments about pagination a lot. The thing I don't know about, though, is the "database is almost always the most constrained part of a solution". On this simple site search, we tend to notice the apaches taking a lot more cpu than the databases calls. I guess when our site gets bigger, you'd imagine it is easier to scale out the apaches than the database (with sharding), but we would still have a lot of room to improve the mysql layer anyway (memcached for example).