phpgroupware-users
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Phpgroupware-users] SLOW database with redundant queries


From: Roy Sigurd Karlsbakk
Subject: [Phpgroupware-users] SLOW database with redundant queries
Date: Mon, 16 Dec 2002 14:06:16 +0100
User-agent: KMail/1.4.1

hi all

the following output is from phpgroupware running. it's only from the point 
where I click the 'mail' button, and it generates LOTS of database traffic. 
Output is from postgresql -d 4.

As you may see, the queries are repeated, and it all eats cpu. It did help 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]$

-- 
Roy Sigurd Karlsbakk, Datavaktmester
ProntoTV AS - http://www.pronto.tv/
Tel: +47 9801 3356

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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]