diff options
author | Yorhel <git@yorhel.nl> | 2013-01-05 13:06:18 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2013-01-05 13:06:18 +0100 |
commit | 5fb01aeb58c77d2abda4e11d72be2217215a0ce5 (patch) | |
tree | 5d59608330ebb3879b9183cbe239d356aa13151f /util | |
parent | a208fac4225ab8775a57c72eca0f042ee743b7bc (diff) |
Don't use Multi for processing VN cover images
I used to do this to avoid loading Image::Magick in each TUWF process,
decreasing memory usage, and lowering the blocking time by avoiding too
much processing. Memory isn't much of a problem nowadays, and processing
images is fast enough, too, so this complexity isn't necessary anymore.
(Character images and screenshots pending)
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/all.sql | 1 | ||||
-rw-r--r-- | util/sql/func.sql | 7 | ||||
-rw-r--r-- | util/updates/update_2.23.sql | 6 |
3 files changed, 6 insertions, 8 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql index 68739776..94e8bf41 100644 --- a/util/sql/all.sql +++ b/util/sql/all.sql @@ -64,7 +64,6 @@ CREATE TRIGGER vn_anime_aid_edit BEFORE UPDATE ON vn_anime CREATE TRIGGER anime_fetch_notify AFTER INSERT OR UPDATE ON anime FOR EACH ROW WHEN (NEW.lastfetch IS NULL) EXECUTE PROCEDURE anime_fetch_notify(); -CREATE TRIGGER vn_rev_image_notify AFTER INSERT OR UPDATE ON vn_rev FOR EACH ROW WHEN (NEW.image < 0) EXECUTE PROCEDURE vn_rev_image_notify(); CREATE TRIGGER chars_rev_image_notify AFTER INSERT OR UPDATE ON chars_rev FOR EACH ROW WHEN (NEW.image < 0) EXECUTE PROCEDURE chars_rev_image_notify(); CREATE TRIGGER screenshot_process_notify AFTER INSERT OR UPDATE ON screenshots FOR EACH ROW WHEN (NEW.processed = FALSE) EXECUTE PROCEDURE screenshot_process_notify(); diff --git a/util/sql/func.sql b/util/sql/func.sql index e5be2fde..261ce9ad 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -603,13 +603,6 @@ $$ LANGUAGE plpgsql; --- Send a notify when a new cover image is uploaded -CREATE OR REPLACE FUNCTION vn_rev_image_notify() RETURNS trigger AS $$ - BEGIN NOTIFY coverimage; RETURN NULL; END; -$$ LANGUAGE plpgsql; - - - -- Send a notify when a new character image is uploaded CREATE OR REPLACE FUNCTION chars_rev_image_notify() RETURNS trigger AS $$ BEGIN NOTIFY charimage; RETURN NULL; END; diff --git a/util/updates/update_2.23.sql b/util/updates/update_2.23.sql index 4464053c..1846593d 100644 --- a/util/updates/update_2.23.sql +++ b/util/updates/update_2.23.sql @@ -52,3 +52,9 @@ UPDATE vn SET c_rating = (SELECT ( ALTER TYPE prefs_key ADD VALUE 'vn_list_own' AFTER 'notify_announce'; ALTER TYPE prefs_key ADD VALUE 'vn_list_wish' AFTER 'vn_list_own'; + + +-- Image processing doesn't happen via Multi anymore, so no more notifications + +DROP TRIGGER vn_rev_image_notify ON vn_rev; +DROP FUNCTION vn_rev_image_notify(); |