diff options
author | Andrew Dolgov <[email protected]> | 2007-05-18 05:16:33 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2007-05-18 05:16:33 +0100 |
commit | 469219162f0a3cb51f53bd1b4172c3b424be1ec0 (patch) | |
tree | fcd959c5457f95c3e29de31490334a4a530eb5ad /functions.php | |
parent | 947c61863e96225bf2bb8b45c141eed776201874 (diff) |
increase performance of queryFeedHeadlines request
Diffstat (limited to 'functions.php')
-rw-r--r-- | functions.php | 20 |
1 files changed, 16 insertions, 4 deletions
diff --git a/functions.php b/functions.php index ba8c4e6a6..ec234ddc2 100644 --- a/functions.php +++ b/functions.php @@ -2532,7 +2532,7 @@ $query = "SELECT guid, ttrss_entries.id,ttrss_entries.title, - SUBSTRING(updated,1,16) as updated, + updated, unread,feed_id,marked,link,last_read, SUBSTRING(last_read,1,19) as last_read_noms, $vfeed_query_part @@ -2563,7 +2563,7 @@ $result = db_query($link, "SELECT guid, ttrss_entries.id as id,title, - SUBSTRING(updated,1,16) as updated, + updated, unread,feed_id, marked,link,last_read, SUBSTRING(last_read,1,19) as last_read_noms, @@ -3564,6 +3564,8 @@ function outputHeadlinesList($link, $feed, $subop, $view_mode, $limit, $cat_view, $next_unread_feed, $offset) { + $timing_info = getmicrotime(); + $topmost_article_ids = array(); if (!$offset) $offset = 0; @@ -3636,9 +3638,13 @@ $real_offset = $offset * $limit; + if ($_GET["debug"]) $timing_info = print_checkpoint("H0", $timing_info); + $qfh_ret = queryFeedHeadlines($link, $feed, $limit, $view_mode, $cat_view, $search, $search_mode, $match_on, false, $real_offset); + if ($_GET["debug"]) $timing_info = print_checkpoint("H1", $timing_info); + $result = $qfh_ret[0]; $feed_title = $qfh_ret[1]; $feed_site_url = $qfh_ret[2]; @@ -3723,10 +3729,10 @@ # $line["title"] . "</a>"; if (get_pref($link, 'HEADLINES_SMART_DATE')) { - $updated_fmt = smart_date_time(strtotime($line["updated"])); + $updated_fmt = smart_date_time(strtotime($line["updated_noms"])); } else { $short_date = get_pref($link, 'SHORT_DATE_FORMAT'); - $updated_fmt = date($short_date, strtotime($line["updated"])); + $updated_fmt = date($short_date, strtotime($line["updated_noms"])); } if (get_pref($link, 'SHOW_CONTENT_PREVIEW')) { @@ -3928,4 +3934,10 @@ $key . '">' . $key . '</a> '; } } + + function print_checkpoint($n, $s) { + $ts = getmicrotime(); + echo sprintf("<!-- CP[$n] %.4f seconds -->", $ts - $s); + return $ts; + } ?> |