aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim
diff options
context:
space:
mode:
authorSean Dague2008-07-16 22:16:46 +0000
committerSean Dague2008-07-16 22:16:46 +0000
commit2a30e85c97097794328b59c1c9691cd44e20b7b4 (patch)
tree9c4c25fd660ea7a26a9ef0696667b1c5d7751fb1 /OpenSim
parentclean up mappings for parent id (diff)
downloadopensim-SC-2a30e85c97097794328b59c1c9691cd44e20b7b4.zip
opensim-SC-2a30e85c97097794328b59c1c9691cd44e20b7b4.tar.gz
opensim-SC-2a30e85c97097794328b59c1c9691cd44e20b7b4.tar.bz2
opensim-SC-2a30e85c97097794328b59c1c9691cd44e20b7b4.tar.xz
added index to ParentID on prims, as this is sorted on for prim loading.
This should speed up initial load of prims, especially on primy regions.
Diffstat (limited to 'OpenSim')
-rw-r--r--OpenSim/Data/MySQL/Resources/012_RegionStore.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/012_RegionStore.sql b/OpenSim/Data/MySQL/Resources/012_RegionStore.sql
new file mode 100644
index 0000000..95c2757
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/012_RegionStore.sql
@@ -0,0 +1,5 @@
1BEGIN;
2
3ALTER TABLE prims add index prims_parentid(ParentID);
4
5COMMIT; \ No newline at end of file