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 | |
| parent | clean up mappings for parent id (diff) | |
| download | opensim-SC_OLD-2a30e85c97097794328b59c1c9691cd44e20b7b4.zip opensim-SC_OLD-2a30e85c97097794328b59c1c9691cd44e20b7b4.tar.gz opensim-SC_OLD-2a30e85c97097794328b59c1c9691cd44e20b7b4.tar.bz2 opensim-SC_OLD-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.
| -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 | ||