diff options
| author | Simon Rettberg | 2017-01-13 13:19:40 +0100 |
|---|---|---|
| committer | Simon Rettberg | 2017-01-13 13:19:40 +0100 |
| commit | db3d963ebc1998cf1941212643914d6e5ae20af3 (patch) | |
| tree | b7a152d842c160bd9db0e80fde85139bb23b80a5 /dozentenmodulserver/src/main/java/org/openslx | |
| parent | [server] DbImageBlock: Formatting (diff) | |
| download | tutor-module-db3d963ebc1998cf1941212643914d6e5ae20af3.tar.gz tutor-module-db3d963ebc1998cf1941212643914d6e5ae20af3.tar.xz tutor-module-db3d963ebc1998cf1941212643914d6e5ae20af3.zip | |
[server] Get rid of imagebase entries without imageversion a bit faster
Diffstat (limited to 'dozentenmodulserver/src/main/java/org/openslx')
| -rw-r--r-- | dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java index eb5bebff..79b16e66 100644 --- a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java +++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbImage.java @@ -849,8 +849,11 @@ public class DbImage { // Get all image base entries which have no image version MysqlStatement sel = connection.prepareStatement("SELECT i.imagebaseid FROM imagebase i" + " LEFT JOIN imageversion v USING (imagebaseid)" - + " WHERE i.updatetime < :cutoff AND v.imageversionid IS NULL"); - sel.setLong("cutoff", Util.unixTime() - 86400 * 14); + + " WHERE (" + + " i.updatetime < :cutoff1 OR (i.updatetime < :cutoff2 AND (i.updatetime - i.createtime) < 600))" + + " AND v.imageversionid IS NULL"); + sel.setLong("cutoff1", Util.unixTime() - 86400 * 14); + sel.setLong("cutoff2", Util.unixTime() - 3600 * 2); ResultSet rs = sel.executeQuery(); // Now delete them all MysqlStatement stmt = connection.prepareStatement("DELETE FROM imagebase" |