On 2017-06-06 11:38 AM, Andreas Hummelbrunner wrote:

Hello Aledr,

Is the seconds Attachment especially large or in any other way "special"? (Characters in filenames, etc...)
That could be an issue.

Also: Check if you're saving attachments on the Filesystem or in the Database and log the corresponding events.

Regards,
Andreas

Am 03.06.2017 um 00:49 schrieb aledr:

Hi!

Had some complains about performance and noticed that:

otrs/index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=108240;FileID=1 <http://index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=108240;FileID=1>
Took 99ms

otrs/index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=108240;FileID=2 <http://index.pl?Action=AgentTicketAttachment;Subaction=HTMLView;ArticleID=108240;FileID=2>
Took 30s

What would be the reason?

Please provide more information:

One single server or DB on another?
What operating system?
Does this request take the same amount of time every time, if you run it 2 or 3 times in a row?
Did you check your operating system monitoring tool to what happens when you run this query? CPU usage high? Disk latency? Swapping?

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs