Re: [otrs] DBI:ODBC performance for MSSQL

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 wrote:

Hi Hugh,

On Tue, Nov 15, 2011 at 16:54, Hugh Kelley 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