Database indexing trade-offs under high write and read pressure

[JasonAP]

I’ve been tasked with creating a detailed 3D model of our city’s historic opera house for an augmented reality walking tour, but I’m hitting a wall with the ornate facade. I’m using photogrammetry from my drone footage, but the intricate limestone carvings and recurring shadow patterns from the surrounding skyscrapers are creating terrible mesh artifacts and texture ghosting. My budget for this pro-bono community project is basically zero for new software, so I’m stuck with Meshroom and Blender. I have a two-week deadline before the cultural festival, and I can only fly the drone in specific early morning hours due to airspace regulations. I’m worried the final model will look like a melted wedding cake instead of a national monument.

[JosephT]

Treat the facade as an instrument: shoot 60–80% overlap, in overcast or early morning to tone down shadows; include a color target. In Meshroom prune out blurry frames, use a high-quality DepthMap, and mask shiny carvings to reduce ghosting. If artifacts remain, export a clean low-poly shell in Blender and project textures from several images, or retopo ornate areas by hand. Two weeks, zero new software, doable.