Re: [otrs] Question about Database Connection (mssql)

2008-12-16 Thread Michiel Beijen
stem in a large > operational environment and these results are blocking its usage > > Best Regards > John > > --- On Tue, 12/16/08, Michiel Beijen wrote: > > From: Michiel Beijen > Subject: Re: [otrs] Question about Database Connection (mssql) > To: jlat...@yahoo.com

Re: [otrs] Question about Database Connection (mssql)

2008-12-16 Thread John Late
Regards John --- On Tue, 12/16/08, Michiel Beijen wrote: From: Michiel Beijen Subject: Re: [otrs] Question about Database Connection (mssql) To: jlat...@yahoo.com Cc: "User questions and discussions about OTRS." Date: Tuesday, December 16, 2008, 1:32 PM My connection string was exactl

Re: [otrs] Question about Database Connection (mssql)

2008-12-16 Thread Michiel Beijen
hank you very much > Regards > John > > --- On Tue, 12/16/08, Michiel Beijen wrote: > > From: Michiel Beijen > Subject: Re: [otrs] Question about Database Connection (mssql) > To: jlat...@yahoo.com, "User questions and discussions about OTRS." > > Date: T

Re: [otrs] Question about Database Connection (mssql)

2008-12-16 Thread John Late
)?   Thank you very much Regards John   --- On Tue, 12/16/08, Michiel Beijen wrote: From: Michiel Beijen Subject: Re: [otrs] Question about Database Connection (mssql) To: jlat...@yahoo.com, "User questions and discussions about OTRS." Date: Tuesday, December 16, 2008, 12:49 PM John

Re: [otrs] Question about Database Connection (mssql)

2008-12-16 Thread Michiel Beijen
John, What is exactly slow in your setup? Have you tried something like iperf to make sure that it is not a bandwith issue from your OTRS box to the mssql box? Have you measured the query on the Microsoft SQL server end to make sure that there is no way the query can be optimized? What is the load

[otrs] Question about Database Connection (mssql)

2008-12-15 Thread John Late
Hello   I am trying to connect my otrs installation to a mssql database. I am using this connection string but it is really slow and it is impacting the system performance. It connects but the performance is far away from mysql.   $Self->{'Database::Type'} = q/mssql/; $Self->{'Database'} = q/otrs/