diff options
author | Sean Dague | 2008-07-16 22:16:46 +0000 |
---|---|---|
committer | Sean Dague | 2008-07-16 22:16:46 +0000 |
commit | 2a30e85c97097794328b59c1c9691cd44e20b7b4 (patch) | |
tree | 9c4c25fd660ea7a26a9ef0696667b1c5d7751fb1 /OpenSim | |
parent | clean up mappings for parent id (diff) | |
download | opensim-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.sql | 5 |
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 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | ALTER TABLE prims add index prims_parentid(ParentID); | ||
4 | |||
5 | COMMIT; \ No newline at end of file | ||