Hope this question isn't too vague.
I was wondering if there was any documentation or guidance on the database(s) underpinning Craft?
I am going to be working on a website with a fair amount of data and, crucially, the need to pull quite a lot of pieces of data frequently.
You can see a version of it here: http://unlockinglovelocks.co.uk
At the moment, using the dropdowns, you can navigate to a large picture which is mapped, so that clicking on each padlock will bring up its details. Eventually, my friend who requested the site expects to catalog a large number of these (potentially several large images, each featuring dozens of locks, related to just one site --- multiple sites per area --- multiple areas)
Am looking for a setup that won't end up being slow or inefficient. Basically want to understand a bit more about how the data storage with Craft works, so I can try and do it right :p
Any recommended resources would be welcome - I have had a google, and a browse of the Craft docs, without much luck.