diff options
author | Andrew Dolgov <[email protected]> | 2006-03-21 08:09:18 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2006-03-21 08:09:18 +0100 |
commit | 894ebcf5e94c917f5e10e5196f74b8055e2b2407 (patch) | |
tree | a6ae843d7622de23a464e43b00942fdf00a27006 /backend.php | |
parent | ac92cb46be4fad924be5e03f46fed7000c3dea81 (diff) |
update_daemon work, remove unneeded indexes, query optimizations
Diffstat (limited to 'backend.php')
-rw-r--r-- | backend.php | 14 |
1 files changed, 9 insertions, 5 deletions
diff --git a/backend.php b/backend.php index 06e7a4756..39628f58e 100644 --- a/backend.php +++ b/backend.php @@ -5,13 +5,13 @@ header("Pragma: no-cache"); header("Expires: -1"); - if ($_GET["debug"]) { +/* if ($_GET["debug"]) { define('DEFAULT_ERROR_LEVEL', E_ALL); } else { define('DEFAULT_ERROR_LEVEL', E_ERROR | E_WARNING | E_PARSE); } - - error_reporting(DEFAULT_ERROR_LEVEL); + + error_reporting(DEFAULT_ERROR_LEVEL); */ $op = $_REQUEST["op"]; @@ -1490,7 +1490,7 @@ // $content_query_part = ""; // } - $result = db_query($link, "SELECT + $query = "SELECT ttrss_entries.id,ttrss_entries.title, SUBSTRING(updated,1,16) as updated, unread,feed_id,marked,link,last_read, @@ -1507,7 +1507,11 @@ $search_query_part $view_query_part $query_strategy_part ORDER BY $order_by - $limit_query_part"); + $limit_query_part"; + + $result = db_query($link, $query); + + if ($_GET["debug"]) print $query; } else { // browsing by tag |