phpgroupware-users
[Top][All Lists]
Advanced
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-users] Re: SLOW database with redundant queries

From: Brian Jackson
Subject: [Phpgroupware-users] Re: SLOW database with redundant queries
Date: Mon, 16 Dec 2002 14:05:22 -0600
I thought AngleMail was integrated now, or does Angles still keep an external tree and just syncs up every once in awhile? --Brian Jackson Chris Weiss writes: 
in the devel verison of email (anglemail) the session cache handling was 
rewritten
a week or 2 ago.  I don't know how well tested any of this is on pgsql but on 
mysql
it's a lot faster now. 
If you want to try anglemail you can get it at
http://anglemail.org/index.html#install, 
http://anglemail.org/files/anglemail-1.1-
pre8-08.tar.bz2 the latest.  You will need to into setup and "install/upgrade" 
it
because it now its own table for the cache that will need to be installed. 
Roy Sigurd Karlsbakk (address@hidden) wrote*:
hi all 
the following output is from phpgroupware running. it's only from the poi
nt
where I click the 'mail' button, and it generates LOTS of database traffi
c.
Output is from postgresql -d 4. 
As you may see, the queries are repeated, and it all eats cpu. It did hel
p a
little to index the table, but not a whole lot. any ideas how to easily fix this? roy 
address@hidden roy]$ grep -w query mail.pgsql.history
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=msg_structure'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=phpgw_header'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=msg_structure'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=phpgw_header'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=msg_structure'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=phpgw_header'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=msg_structure'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=phpgw_header'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=msg_structure'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=phpgw_header'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=msg_structure'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=phpgw_header'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=msg_structure'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=phpgw_header'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=msg_structure'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=phpgw_header'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=msg_structure'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=phpgw_header'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=msg_structure'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=phpgw_header'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=msg_structure'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=phpgw_header'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=msg_structure'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=phpgw_header'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=msg_structure'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=phpgw_header'
DEBUG:  query: select count(session_id) from phpgw_sessions
DEBUG:  query: SELECT app_name,app_version FROM phpgw_applications WHERE
app_name='email' OR app_name='phpgwapi'
DEBUG:  query: select count(*) from phpgw_messenger_messages where
message_owner='6' and message_status='N'
DEBUG:  query: SELECT content FROM phpgw_app_sessions WHERE
sessionid='9f4339f5d90604ac491ef29b13d8e445' AND loginid='6' AND app
=
'email' AND location='acctnum=0;data_name=folder_status_info'
DEBUG:  query: BEGIN;ROLLBACK;
address@hidden roy]$ 

Computers are like air conditioners.
They stop working when you open Windows. 


_______________________________________________
Phpgroupware-users mailing list
address@hidden
http://mail.gnu.org/mailman/listinfo/phpgroupware-users 

_______________________________________________
Phpgroupware-users mailing list
address@hidden
http://mail.gnu.org/mailman/listinfo/phpgroupware-users
reply via email to
[Prev in Thread] Current Thread [Next in Thread]