In InfoPath preview mode everything is fine, data connection on the list of 15000 items is populating dropdown menu based on a filter(I am only looking for two rows so filtering is implanted). Once published in Central Administration, form doesn't open -it is stuck at loading.
I have inherited development of this form and there is a connection to a similar list that works in an instance(both connection strings are searching for employees attributes). Is it possible that the data connection that doesn't effect the InfoPath performance contains parameters(filters in the connection string-since the filter are not implemented on InfoPath fields)?
My connection string is killing the performance of the form.
Please help me in querying filtered values in a large list(I am not saving a copy of the list in the form).