Timeline for Speed up count queries on a couple million rows
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Nov 2, 2016 at 0:22 | comment | added | Erwin Brandstetter |
@dvcrn: A large OFFSET is typically almost as expensive as if you would increase LIMIT by the same amount. It depends on details of your query, tables and indexes. Related answers here or here. But this is hardly related to your original question any more. Please ask a new question if you still need it.
|
|
| Nov 2, 2016 at 0:09 | comment | added | patchrail |
Interesting, I see! Given memory and resource limitations I have to LIMIT the query to a sane size. However even with a small size like LIMIT 10 and a offset of 1.000.000, the query becomes unusably slow. Would you happen to have any advise for this particular case?
|
|
| Oct 31, 2016 at 5:22 | history | edited | Erwin Brandstetter | CC BY-SA 3.0 |
added 172 characters in body
|
| Oct 31, 2016 at 5:10 | history | answered | Erwin Brandstetter | CC BY-SA 3.0 |