Index: openacs-4/packages/news-aggregator/tcl/source-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/tcl/source-procs-postgresql.xql,v diff -u -r1.9 -r1.10 --- openacs-4/packages/news-aggregator/tcl/source-procs-postgresql.xql 18 Jul 2018 09:08:18 -0000 1.9 +++ openacs-4/packages/news-aggregator/tcl/source-procs-postgresql.xql 5 Oct 2021 10:36:15 -0000 1.10 @@ -4,12 +4,6 @@ postgresql7.2 - - - limit $limit - - - select na_source__new ( Index: openacs-4/packages/news-aggregator/tcl/source-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/tcl/source-procs.tcl,v diff -u -r1.22 -r1.23 --- openacs-4/packages/news-aggregator/tcl/source-procs.tcl 20 Jan 2020 17:10:46 -0000 1.22 +++ openacs-4/packages/news-aggregator/tcl/source-procs.tcl 5 Oct 2021 10:36:15 -0000 1.23 @@ -277,21 +277,20 @@ if { $source_count >= 1 } { if { !$all_sources_p } { set limit [expr {max(1, int($source_count/4))}] - set limit_sql [db_map sources_limit] } else { - set limit_sql "" + set limit "" } - foreach source [db_list_of_lists sources [subst { + foreach source [db_list_of_lists sources { select source_id, feed_url, last_modified from na_sources where :all_sources_p or last_scanned < (current_timestamp - interval '48 minutes') order by last_scanned asc - $limit_sql - }]] { + fetch first :limit rows only + }] { lassign $source source_id feed_url last_modified news_aggregator::source::update \ -source_id $source_id \