Hi all Hopefully some light can be shed on the problem we're experiencing - otrs is rapidly becoming unusable in our case (and we *really* don't want to abandon it).
This is either a database/sql issue, or some other issue related to otrs. Scenario: agent has approx. 315 locked tickets, with 292-odd tickets in 'new messages' queue. Clicking on the 'locked tickets' queue (to display the tickets) results in a delay of 30-60 minutes... Opening a normal queue with 17 tickets results in a delay of about 45 seconds. So, quite a problem. The following is our setup: apache 1.3.31, mod_perl, mod_php, mod_* etc. Documented mod_perl/otrs setup was followed. Using Postgres 7.4.2. With Postgresql config: log_statement = true log_duration = true I see zillions of the following: SELECT sdt.name, sa.create_by, st.until_time FROM article_sen der_type sdt, article sa, ticket st WHERE st.id = 3604 AND sa.ticket_id = st.id AND sdt.id = sa.article_sender_type_id ORDER BY sa.create_time LOG: duration: 533.672 ms - 800ms SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject, sa.a_reply_to, sa. a_message_id, sa.a_body, st.create_time_unix, t.ticket_state_id, st.queue_id, sa.create_time, sa.a_content_type, sa.create_by, st.tn, article_sender_type_id, st.customer_id, st.until_time, st.ticket_priority_id, st.customer_user_id, st.user_id, su.login, sa.article_type_id, sa.a_freekey1, sa.a_freetext1, sa.a_freekey2, sa.a_freetext2, sa.a_freekey3, sa.a_freetext3, st.ticket_answered, sa.incoming_time, sa.id, st.freekey1, st.freetext1, st.freekey2, st.freetext2, st.freekey3, st.freetext3, st.freekey4, st.freetext4, st.freekey5, st.freetext5, st.freekey6, st.freetext6, st.freekey7, st.freetext7, st.freekey8, st.freetext8 FROM article sa, ticket st, system_user su where sa.id = 44681 AND sa.ticket_id = st.id AND st.user_id = su.id ORDER BY sa.id ASC LOG: duration: 809.421 ms - 1000ms Is otrs performing single and seperate selects for every blimming ticket in the set in question? Tweaking PG parameters really has no impact on this. The server in question is reasonably busy, with lots of memory, a fast processor, etc. Load avg varies between .3 - 1.5. The same server handles bugzilla with stellar performance. What the hell am I missing here? I refuse to give up on otrs just yet. Any help would be appreciated. Henry -------------------------------------------------------- This message was sent using MetroWEB's AirMail service. http://www.metroweb.co.za/ - full access for only R73. Free Web Accelerator, WebMail, Calendar, Anti-Virus, Anti-Spam, 10 emails, 100MB personal webspace, and more! Phone Now! 086 11 11 440 _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
