Hi all,
While searching tickets from search module of otrs, it takes hell lotta time to give results...finally ending up with "Internal Server error". Pullin the SQL script that lists distinct tickets, from code, and running it directly in MYSQL client also takes hell lot of time, processing going into loop. I looked at the count of following huge tables..ticket,ticket_history, article...all shows records > 500000+. Deleting 200000+ rows does bring things back to normal. Searching on various MYSQL related forums i did get a clue that mysql cannot handle joins of huge tables, as is the case with me. Is there anyway out of this situation. Please Suggest. Thanks. Aleem B. --- On Wed, 11/6/08, gian schoeman <[EMAIL PROTECTED]> wrote: > From: gian schoeman <[EMAIL PROTECTED]> > Subject: [otrs] A few questions > To: otrs@otrs.org > Date: Wednesday, 11 June, 2008, 9:19 AM > Hi > > > > I have been testing out OTRS and want to know if you can > view closed > tickets, or open tickets that was assigned to a specific > queue and has been > closed for example. When I look at the agent interface I > can only see > options to view the queues that have messages in a > live/open state. Is it > not possible to view queues which do not currently have > live messages, but > might contain closed cases etc? > > > > I also want to know if it is possible to reset the Full > Qualified System > name that you need to enter when going through the > configuration pages after > you have finished doing so. I do not really want to > reinstall. > > > > Thank you, > > Gian_______________________________________________ > 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 or consulting for your OTRS system? > => http://www.otrs.com/ From Chandigarh to Chennai - find friends all over India. Go to http://in.promos.yahoo.com/groups/citygroups/ _______________________________________________ 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 or consulting for your OTRS system? => http://www.otrs.com/