Hi all, I've just made a OTRS stress test by sending 1000 random generated e-mails (with random number of body parts/attachs). I must say, that OTRS handled it very well, but I noticed one problem - in queue view I have 67 pages of tickets and the funny thing is, that I can see tickets only in fist 8 pages, all the other pages are empty? Howcome? Also if I perform search for those tickets (all of them were sent from one single e-mail address) I get only fist 250 tickets found, where are all the others? I really don't have a clue here, please help! Regards, Alex
Hi Alex, On Wed, Apr 23, 2003 at 11:11:17AM +0200, Alex Mihicinac wrote:
I've just made a OTRS stress test by sending 1000 random generated e-mails (with random number of body parts/attachs). I must say, that OTRS handled it very well, but I noticed one problem - in queue view I have 67 pages of tickets and the funny thing is, that I can see tickets only in fist 8 pages, all the other pages are empty? Howcome? Also if I perform search for those tickets (all of them were sent from one single e-mail address) I get only fist 250 tickets found, where are all the others? I really don't have a clue here, please help!
There are limits for max. shown tickets in QueueView and Utilities. I changed QueueView max. shown tickets from 120 (comes from OTRS 1.0 - shown on one page!!) to 1200. There is also a max. limit for search results. I changed it from 250 to 1000 (If the max. limit has reached then "Total hits" is shown in red!). Thanks for the info Alex! (I updated the CVS)
Alex
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "There are two major products that come out of Berkeley: LSD and Unix. We don't believe this to be a coincidence." -- Jeremy S. Anderson
Hi, Thanks, now it's much better! :) btw... Is there any simple and safe way to delete all tickets/articles from db, but not all the other things (users, settings) in db? Regards, Alex
-----Original Message----- From: otrs-admin@otrs.org [mailto:otrs-admin@otrs.org] On Behalf Of Martin Edenhofer Sent: 24. april 2003 12:47 To: otrs@otrs.org Subject: Re: [otrs] OTRS stress test
Hi Alex,
On Wed, Apr 23, 2003 at 11:11:17AM +0200, Alex Mihicinac wrote:
I've just made a OTRS stress test by sending 1000 random generated e-mails (with random number of body parts/attachs). I must say, that OTRS handled it very well, but I noticed one problem - in queue view I have 67 pages of tickets and the funny thing is, that I can see tickets only in fist 8 pages, all the other pages are empty? Howcome? Also if I perform search for those tickets (all of them were sent from one single e-mail address) I get only fist 250 tickets found, where are all the others? I really don't have a clue here, please help!
There are limits for max. shown tickets in QueueView and Utilities.
I changed QueueView max. shown tickets from 120 (comes from OTRS 1.0 - shown on one page!!) to 1200.
There is also a max. limit for search results. I changed it from 250 to 1000 (If the max. limit has reached then "Total hits" is shown in red!).
Thanks for the info Alex!
(I updated the CVS)
Alex
Martin
-- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "There are two major products that come out of Berkeley: LSD and Unix. We don't believe this to be a coincidence." -- Jeremy S. Anderson
_______________________________________________ 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
Hi Alex, On Fri, Apr 25, 2003 at 10:40:04AM +0200, Alex Mihicinac wrote:
Thanks, now it's much better! :) btw... Is there any simple and safe way to delete all tickets/articles from db, but not all the other things (users, settings) in db?
If you want to remove all existing ticket/articles/attachments from db use: delete from article; delete from article_attachment; delete from article_plain; delete from ticket_history; delete from ticket;
Alex
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "The number of Unix installations has grown to 10, with more expected." The Unix Programmer's Manual, 2nd Edition, June 1972
participants (2)
-
Alex Mihicinac -
Martin Edenhofer