diff options
Diffstat (limited to 'OpenSim/Data/MySQL')
| -rw-r--r-- | OpenSim/Data/MySQL/MySQLLegacyRegionData.cs | 32 |
1 files changed, 18 insertions, 14 deletions
diff --git a/OpenSim/Data/MySQL/MySQLLegacyRegionData.cs b/OpenSim/Data/MySQL/MySQLLegacyRegionData.cs index c07963c..a807948 100644 --- a/OpenSim/Data/MySQL/MySQLLegacyRegionData.cs +++ b/OpenSim/Data/MySQL/MySQLLegacyRegionData.cs | |||
| @@ -66,22 +66,26 @@ namespace OpenSim.Data.MySQL | |||
| 66 | Migration m = new Migration(m_Connection, assem, "RegionStore"); | 66 | Migration m = new Migration(m_Connection, assem, "RegionStore"); |
| 67 | m.Update(); | 67 | m.Update(); |
| 68 | 68 | ||
| 69 | // NOTE: This is a very slow query that times out on regions with a lot of prims. | ||
| 70 | // I'm told that it is no longer relevant so it's commented out now, but if it | ||
| 71 | // is relevant it should be added as a console command instead of part of the | ||
| 72 | // startup phase | ||
| 69 | // Clean dropped attachments | 73 | // Clean dropped attachments |
| 70 | // | 74 | // |
| 71 | try | 75 | //try |
| 72 | { | 76 | //{ |
| 73 | using (MySqlCommand cmd = m_Connection.CreateCommand()) | 77 | // using (MySqlCommand cmd = m_Connection.CreateCommand()) |
| 74 | { | 78 | // { |
| 75 | cmd.CommandText = "delete from prims, primshapes using prims " + | 79 | // cmd.CommandText = "delete from prims, primshapes using prims " + |
| 76 | "left join primshapes on prims.uuid = primshapes.uuid " + | 80 | // "left join primshapes on prims.uuid = primshapes.uuid " + |
| 77 | "where PCode = 9 and State <> 0"; | 81 | // "where PCode = 9 and State <> 0"; |
| 78 | ExecuteNonQuery(cmd); | 82 | // ExecuteNonQuery(cmd); |
| 79 | } | 83 | // } |
| 80 | } | 84 | //} |
| 81 | catch (MySqlException ex) | 85 | //catch (MySqlException ex) |
| 82 | { | 86 | //{ |
| 83 | m_log.Error("[REGION DB]: Error cleaning up dropped attachments: " + ex.Message); | 87 | // m_log.Error("[REGION DB]: Error cleaning up dropped attachments: " + ex.Message); |
| 84 | } | 88 | //} |
| 85 | } | 89 | } |
| 86 | 90 | ||
| 87 | private IDataReader ExecuteReader(MySqlCommand c) | 91 | private IDataReader ExecuteReader(MySqlCommand c) |