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
Hi Hugh,
Yes, I am aware of these changes, and I was the one mentioned by
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
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