From: SJ.Stanaitis <sst...@dp...> - 2007-02-02 13:55:37
|
Also, it appears that the mm_ticket table is the one with problems, any update, insert, or delete queries are lagging big time. Thanks, Sam SJ.Stanaitis - Network Administrator Decorative Product Source E-commerce Network -----Original Message----- From: mai...@li... [mailto:mai...@li...] On Behalf Of SJ.Stanaitis Sent: Friday, February 02, 2007 8:21 AM To: sst...@dp...; 'Kevin Campbell' Cc: 'Logicalware Mailmanager-users' Subject: [Mailmanager-users] MM 2.0.9 PSQL 8.0.6 Woes... (Accidentally posted with wrong subject earlier) I had set up a script on my Slackware box to re-assign tickets older than 1 year to a specific Archive user, as I discovered that either due to performance issues on my system or MM when an active user gets a LARGE number of tickets (say over 20K) the entire system would slow down. Long story short, the script ran the other night, or tried to, and now MM is CRAWLING. The queries still go through without error, but the PSQL database is taking its sweet time to respond. I'm running PSQL 8.0.6 and MM 2.0.9. Awhile back I had inquired as to how I might delete tickets from the database manually, and did not receive a response so I used the following query: DELETE FROM mm_ticket WHERE date_closed LIKE "200x- %"; Now I've discovered that while the mm_ticket table gets updated, and the tickets are no longer displayed, the messages are still stored in the mm_message table. Could that be part of the speed issue, all those un-linked messages? Is there any way to sync up the two tables, or export the active tickets, wipe the tables, and restore them? Thanks, Sam SJ.Stanaitis - Network Administrator Decorative Product Source E-commerce Network ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Mailmanager-users mailing list Mai...@li... https://lists.sourceforge.net/lists/listinfo/mailmanager-users |