[Top][All Lists]
[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.
- [Phpgroupware-users] SLOW database with redundant queries,
Roy Sigurd Karlsbakk <=