diff options
| author | Sean Dague | 2008-06-12 20:48:06 +0000 |
|---|---|---|
| committer | Sean Dague | 2008-06-12 20:48:06 +0000 |
| commit | 1451d6fb9a4976e5846d17524e1b43affeba0863 (patch) | |
| tree | 08846913994de3a6cfb38ce0f08907385d4c71d7 /OpenSim/Data/MySQL/Resources/002_RegionStore.sql | |
| parent | * Split the World Map code into a module. (diff) | |
| download | opensim-SC-1451d6fb9a4976e5846d17524e1b43affeba0863.zip opensim-SC-1451d6fb9a4976e5846d17524e1b43affeba0863.tar.gz opensim-SC-1451d6fb9a4976e5846d17524e1b43affeba0863.tar.bz2 opensim-SC-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/002_RegionStore.sql')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/002_RegionStore.sql | 6 |
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 @@ | |||
| 1 | BEGIN; | ||
| 2 | |||
| 3 | CREATE index prims_regionuuid on prims(RegionUUID); | ||
| 4 | CREATE index primitems_primid on primitems(primID); | ||
| 5 | |||
| 6 | COMMIT; \ No newline at end of file | ||