From 6bd41e8f6931366c0967e0846b4f2630761bc85e Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Mon, 14 May 2007 06:36:57 +0000
Subject: Another performance patch

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@1184 4979c152-3d1c-0410-bac9-87ea11338e46
---
 LedgerSMB/Form.pm | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

diff --git a/LedgerSMB/Form.pm b/LedgerSMB/Form.pm
index 8cc59544..f15ee00a 100755
--- a/LedgerSMB/Form.pm
+++ b/LedgerSMB/Form.pm
@@ -1490,6 +1490,7 @@ sub db_init {
 
     $self->{dbh}->do( $date_query{ $myconfig->{dateformat} } );
     $self->{db_dateformat} = $myconfig->{dateformat};    #shim
+    #$self->{dbh}->do('set log_statement to \'all\'');
 
     my $query = "SELECT t.extends, 
 			coalesce (t.table_name, 'custom_' || extends) 
@@ -2159,8 +2160,10 @@ sub all_years {
 
     # get years
     my $query = qq|
-		SELECT (SELECT MIN(transdate) FROM acc_trans),
-		       (SELECT MAX(transdate) FROM acc_trans)|;
+                SELECT (SELECT transdate FROM acc_trans ORDER BY transdate asc
+                                LIMIT 1),
+                       (SELECT transdate FROM acc_trans ORDER BY transdate desc
+                                LIMIT 1)|;
 
     my ( $startdate, $enddate ) = $dbh->selectrow_array($query);
 
-- 
cgit v1.2.3