I'd genuinely have to go back through all the notes I made to answer your questions.
One of the biggest problems is the sheer size of the database, so yeah it's probably to do with how that is set up.
The best thing would be for someone who knows what they're on about to get access to everything, and do some digging. Everything coming through me would be laughably basic.