Interested in advertising on Derpibooru? Click here for information!
Sky Railroad Merch Shop!

Help fund the $15 daily operational cost of Derpibooru - support us financially!

Description

Anyone else having this issue?

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

Comments

Syntax quick reference: **bold** *italic* ||hide text|| `code` __underline__ ~~strike~~ ^sup^ ~sub~

Detailed syntax guide

Carcer
Bronze Bit -
Happy Derpy! -
A Perfectly Normal Pony - <Carcer> "Officer, unless I threatened to **** him in the ass, I don't believe I could have reasonably expected him to stop using my website."
Since the Beginning  - Posted the very first image. Indexes start at zero!

Inexplicably in power
Like Clover says in our most recent newspost, the pagination system is the major cause of performance issues with the site. Basically, the thing is that mongodb cannot do counts efficiently - and the pagination system we were using requires the system to check the number of images in a given collection to work out how many page numbers to show and where the “last page” button should be pointing. Every time someone looked at any gallery page on the site, the system went and one-by-one counted basically every image in the database the met the filtering/search restrictions for that user to work out where the last page would be.
 
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:
 
full
 
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.