You're using MS-SQL 2008; this requires ODBC connection and is slower than running on MySQL or PostgreSQL.
Can you please check this link: http://bugs.otrs.org/show_bug.cgi?id=5023#c8 And change the value of LongReadLen to a lower value. Does that affect performance? I'm not sure what exact side-effects it would have at this point, please be warned! -- Mike On Thu, May 12, 2011 at 3:04 PM, Hugh Kelley <[email protected]> wrote: > I have now, thanks for the reminder. There were a few items in to tend to > there ( I hadn't enabled Apache:DBI, was missing some minor Perl modules, > etc.) > > I also enabled the performance logging module which should take a lot of > subjectivity out of this. > > Regarding the support module, I tried to run the SQL Benchmark and got a > less than favorable finding. However, when I try to re-run it I don't get a > fresh run. How can I force it to run another benchmark? > > Hugh > > > Has anybody else seen this (Windows 2008, Apache 2.2, SQL Server 2008 > > On Thu, May 12, 2011 at 4:25 AM, Nils Leideck <[email protected]> > wrote: >> >> On 12.05.2011, at 03:53, Hugh Kelley wrote: >> >> > We've been using OTRS for about six month now (9,000 tickets, 62,000 >> > articles) and I'm starting to notice sluggishness. >> > I've tried switching from IIS + PerlEx to Apache + mod_perl but that >> > hasn't made a noticeable difference. >> > My next move is to investigate archiving. Has anyone else had a >> > similar experience? When did others start archiving? What effect did it >> > have? >> > >> > Are there other more obvious places to look next? I've read the tuning >> > guide but it seems like we're pretty small by those standards. >> > http://doc.otrs.org/3.0/en/html/performance-tuning.html >> >> Did you install the Support Assessment module? This one is always a good >> point to start searching for possible enhancements. >> >> Cheers, Nils >> >> -- >> Nils Leideck >> http://webint.cryptonode.de / a Fractal project >> >> --------------------------------------------------------------------- >> 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 > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
