Hello all,
there is more and more mail subscriptions - it means, you are logged in, you search something, click on "mail results" icon at bottom, and you will get new subtitles by mail once a day for that query (if exists such a subtitle(s)) -newest, for certain imdb, movie, language - doesnt matter, also this subscription is made for "request movie".
Problem is, amount of these subscriptions is so high, that server is quite slow when processing them (10660 currently - that means 10660 searches...)
So I am thinking way how to remove old. But not every request should be removed - for example I want get nonstop "newest slovak and czech subtitles" to my mail, so this one should not expire. But expire should for example request for certain movie (I am searching czech/slovak subtitles for movie "who killed electric car"). So my idea is:
delete all "mail results" which are older than 1/2 year and contain request for some movie (moviename, imdbid, movieid...)
what do you think about this ?