From 1451d6fb9a4976e5846d17524e1b43affeba0863 Mon Sep 17 00:00:00 2001
From: Sean Dague
Date: Thu, 12 Jun 2008 20:48:06 +0000
Subject: look mom, migrations in action.  This adds a couple of indexes to
 mysql regions that should help on performance of some of the selects.  We
 should start capturing more data on performance bits to figure out where else
 we are missing indexes and add them via migrations as well.

---
 OpenSim/Data/MySQL/Resources/002_RegionStore.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 OpenSim/Data/MySQL/Resources/002_RegionStore.sql

(limited to 'OpenSim/Data/MySQL/Resources/002_RegionStore.sql')

diff --git a/OpenSim/Data/MySQL/Resources/002_RegionStore.sql b/OpenSim/Data/MySQL/Resources/002_RegionStore.sql
new file mode 100644
index 0000000..45bf959
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/002_RegionStore.sql
@@ -0,0 +1,6 @@
+BEGIN;
+
+CREATE index prims_regionuuid on prims(RegionUUID);
+CREATE index primitems_primid on primitems(primID);
+
+COMMIT;
\ No newline at end of file
-- 
cgit v1.1

