diff options
| author | Thomas Müller <thomas.mueller@tmit.eu> | 2012-11-05 14:06:07 -0800 |
|---|---|---|
| committer | Thomas Müller <thomas.mueller@tmit.eu> | 2012-11-05 14:06:07 -0800 |
| commit | b7e9d8d00e08faa16d67e7469ef5af94dbca7cfc (patch) | |
| tree | 1de953e3e5715d8f1aa0cd5c36b10c47d0f085b8 | |
| parent | f2d5450e141ab37b89b209bd7aab29a97bb343f9 (diff) | |
| parent | 85d6a08ae9803d7b19482b45664200f5980bd356 (diff) | |
| download | nextcloud-server-b7e9d8d00e08faa16d67e7469ef5af94dbca7cfc.tar.gz nextcloud-server-b7e9d8d00e08faa16d67e7469ef5af94dbca7cfc.zip | |
Merge pull request #267 from owncloud/improve_files_update
Improve performance of files update (on larger setups)
| -rw-r--r-- | apps/files/appinfo/update.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/apps/files/appinfo/update.php b/apps/files/appinfo/update.php index 738864d7cff..29782ec643e 100644 --- a/apps/files/appinfo/update.php +++ b/apps/files/appinfo/update.php @@ -5,10 +5,10 @@ $installedVersion=OCP\Config::getAppValue('files', 'installed_version'); if (version_compare($installedVersion, '1.1.6', '<')) { $query = OC_DB::prepare( "SELECT `propertyname`, `propertypath`, `userid` FROM `*PREFIX*properties`" ); $result = $query->execute(); + $updateQuery = OC_DB::prepare('UPDATE `*PREFIX*properties` SET `propertyname` = ? WHERE `userid` = ? AND `propertypath` = ?'); while( $row = $result->fetchRow()) { if ( $row["propertyname"][0] != '{' ) { - $query = OC_DB::prepare( 'UPDATE `*PREFIX*properties` SET `propertyname` = ? WHERE `userid` = ? AND `propertypath` = ?' ); - $query->execute( array( '{DAV:}' + $row["propertyname"], $row["userid"], $row["propertypath"] )); + $updateQuery->execute(array('{DAV:}' + $row["propertyname"], $row["userid"], $row["propertypath"])); } } } |