aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources
diff options
context:
space:
mode:
authorSean Dague2008-06-12 20:48:06 +0000
committerSean Dague2008-06-12 20:48:06 +0000
commit1451d6fb9a4976e5846d17524e1b43affeba0863 (patch)
tree08846913994de3a6cfb38ce0f08907385d4c71d7 /OpenSim/Data/MySQL/Resources
parent* Split the World Map code into a module. (diff)
downloadopensim-SC_OLD-1451d6fb9a4976e5846d17524e1b43affeba0863.zip
opensim-SC_OLD-1451d6fb9a4976e5846d17524e1b43affeba0863.tar.gz
opensim-SC_OLD-1451d6fb9a4976e5846d17524e1b43affeba0863.tar.bz2
opensim-SC_OLD-1451d6fb9a4976e5846d17524e1b43affeba0863.tar.xz
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.
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
-rw-r--r--OpenSim/Data/MySQL/Resources/002_RegionStore.sql6
1 files changed, 6 insertions, 0 deletions
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 @@
1BEGIN;
2
3CREATE index prims_regionuuid on prims(RegionUUID);
4CREATE index primitems_primid on primitems(primID);
5
6COMMIT; \ No newline at end of file