OpenSim-NGC / OpenSim-Tranquillity

OpenSim Core ++. Provides Bug Fixes and some new ideas that enhance the reliability and performance of OpenSim Core Yeti.
Other
23 stars 13 forks source link

Land table has no indexes #61

Open nbtafelberg opened 1 year ago

nbtafelberg commented 1 year ago

I don't know if it's just me but the land table doesn't appear to have any indexes, I added indexes for Region UUID, USer UUID and UUID

renevega commented 8 months ago

Not certain whether you need all those indices. My recollection is that most accesses are by parcel UUID, which are on a primary index. Second most accesses are by way of the in-memory bitmap checks to determine the highest layer, which then references another in-memory associative list that translates the layer directly to a parcel UUID. Third most are general parcel queries based on region. So, yes, an index on RegionUUID could be helpful. I will verify this again in the latest codebase.