Thanks, Michiel.

Do you know the specific technical reason for that?  Overall, we get very good performance from our SQL Server instances on a variety of applications so this has always confused me (but having used OTRS for over a year now, I don't dispute it).

Is this related to the performance of DBD:ODBC relative to DBD:mysql and the other "native" interfaces?

Hugh

On Wed, Nov 16, 2011 at 5:01 AM, Michiel Beijen <michiel.beijen@otrs.com> wrote:
Hi Hugh,

On Tue, Nov 15, 2011 at 16:54, Hugh Kelley <hugh.kelley@gmail.com> wrote:
> Has anyone been following (and better still, testing), the changes to
> DBD::ODBC (post 1.23_4)?
>
> Presumably these were meant to improve the performance of SQL statement
> preparation for MSSQL via ODBC.
>
> http://www.martin-evans.me.uk/node/65

Yes, I am aware of these changes, and I was the one mentioned by
Martin in his blog post complaining about poor DBD::ODBC performance.

Martin Evans made some changes based on findings I reported but OTRS
on Microsoft SQL Server using DBD::ODBC is still *much* slower than on
MySQL, PostgreSQL or Oracle, unfortunately.

Michiel Beijen
Senior Consultant

OTRS BV
Schipholweg 103
2316 XC Leiden
The Netherlands

T: +31 71 8200 255
F: +31 71 8200 254
I: http://www.otrs.com

Making OTRS even better! Exclusive Feature Add-Ons improve usability
of OTRS and extend its functionality: http://j.mp/ndQvZj
---------------------------------------------------------------------
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