RemoteDB validation triggers query

Moderator: crythias

Locked
Bradoskirnirneos
Znuny newbie
Posts: 2
Joined: 22 Feb 2017, 11:00
Znuny Version: 5.0.15

RemoteDB validation triggers query

Post by Bradoskirnirneos »

Hello, i am using OTRS 5.0.15 with remoteDB, each time that i select a value from the list shown on mi remoteDB field triggers ALL the RemoteDB fields.
So, i use my RemoteDB field to a table with +3M entries (with the filter given in the field) and then 5 queries are launched without any kind of filter (one for each remoteDB field i have in the form) making my server cry.
Is there a way to fix it?
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: RemoteDB validation triggers query

Post by jojo »

set up indexes and get a more performant server.
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
Locked