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 needed31436 +-SH safe2278280 +-SH edit181850 +-SH edited screencap96163 +-SH screencap303417 +-SH fluttershy268523 +-SH trixie81843 +-SH twilight sparkle371177 +-SH pegasus541183 +-SH pony1707756 +-SH slowpoke (pokémon)127 +-SH unicorn586025 +-SH derpibooru8185 +-SH g42121046 +-SH adblock6 +-SH butterfly wings961 +-SH button-up shirt630 +-SH cape15615 +-SH caption26854 +-SH clothes677831 +-SH female1908729 +-SH flying59254 +-SH google404 +-SH google chrome410 +-SH gritted teeth20826 +-SH image macro40594 +-SH impact font2014 +-SH jeans7218 +-SH looking at you276274 +-SH magic wand961 +-SH makeup46046 +-SH mare812161 +-SH meme97292 +-SH meta18887 +-SH nervous9357 +-SH open mouth257089 +-SH pants24998 +-SH pills489 +-SH pokémon11546 +-SH shirt44939 +-SH slowpoke344 +-SH smiling430491 +-SH space6840 +-SH spread wings105388 +-SH tab humor44 +-SH url219 +-SH vulgar26365 +-SH wings251638 +-SH youtube3333
Loading...
Loading...
http://www.derpibooru.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.