Performance tip: NPC banking edge cases (#7129)

This is an original write-up for OpenTibiaServers — not copied from elsewhere. Environment: Ubuntu 22.04, 4 vCPU, 8GB RAM, MariaDB 10.11. We logged query times over 200ms on market browse during peak hour. Is there a cleaner way to validate datapack XML before boot? --- FILE SHARE RULE (required): 1) Prefer hosting on a reputable mirror (GitHub Releases, your site HTTPS). 2) Every download link MUST include a VirusTotal analysis URL for that exact file hash. 3) Paste: file name, version, SHA-256, VirusTotal link, supported client/engine, license. 4) Archives without a VirusTotal link will be removed. Example VT link format: https://www.virustotal.com/gui/file/<sha256> Synthetic example package: ots-community-tool-7129.zip SHA-256: 6f74732d73796e7468657469632d66696c652d373132382d6f70656e54696269 VirusTotal: https://www.virustotal.com/gui/file/6f74732d73796e7468657469632d66696c652d373132382d6f70656e54696269 Note: demo hash for seed content only — replace with your real release hash before publishing.

For Windows hosts, mark the service recovery options or it will not auto-restart. Also: please keep the VirusTotal link next to the mirror. Example: https://www.virustotal.com/gui/file/6f74732d73796e7468657469632d66696c652d373132382d6f70656e54696269

Try indexing the player storage lookups; it helped our spawn scripts.

We documented a similar path in our ops notes last month.