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

[Chris Weiss]

there is a stable snapshot in the .14 tree, and there is a seperate release of
anglemail every couple of week or less that is mostly stable and usualy has some
cool new features.  Only once or twice have I ever need to roll back after
upgrading and those times were due my older version of php not having some 
feature
needed to support a new feature in anglemail.  Of course Angles added a bit more
code to quitely disable the feature if php claimed to not support it.

Brian Jackson (address@hidden) wrote*:
>
>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
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>