View Issue Details

IDProjectCategoryView StatusLast Update
0014029phpList 3 pluginsGeneralpublic06-02-19 11:35
Reporterflohack Assigned To 
Status newResolutionopen 
Summary0014029: Selection of RSS items to send to users is redundant and time consuming
DescriptionThe current version of the RSS integration first selects all items to send to a specific user in rrslib.php by means of an "IN" comparison and sorts them by date, title etc. The result array containing only keys is then given back to the calling sendemaillib.php where the selection is done again from scratch with an inefficient "IN" operator, and then sorted again by list and date.

This approach is time consuming, loading the DB server with unnecessary queries, sorts and compares. Better, eliminate the duplicate sorting, and consider using the result set from the first query not only to give back the keys but all fields, and to avoid the selection a second time.
Additional InformationWe are currently investigating speed and performance problems of phplist with RSS on a server setup where the MySQL server experiences abnormal load conditions during the weekly emmission to about 4000 user.
TagsNo tags attached.



02-10-10 17:12

reporter   ~0051105


BUMP - this is an important issue for admins on shared hosting - it could lead to suspended hosting accounts and needs more urgent review


Issue History

Date Modified Username Field Change
09-04-08 10:15 flohack New Issue
20-04-10 03:30 h2b2 Target Version => 2.11.4
02-10-10 17:12 gazouteast Note Added: 0051105
04-06-13 12:24 michiel Project phpList 3 application => rssmanager
04-06-13 12:24 michiel Category RSS => General
06-02-19 11:35 erion Project rssmanager => phpList 3 plugins