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

[Chris Weiss]

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
>