Hi,



In my InfoPath form I have a Main Connection defined like this (a sample query given below),



select field 1, field 2, field 3, field 4, field 5 from table 1
append
select ... from table 2
append
select ... from table 3
append
select ... from table 4
append
select ... from table 5


all the above tables are related with 'ID' column.


My form contains 3 differnt views.

1st view is used for quering information from table 1 based on field 1 and field 2 values.
Remaining 2 views uses other tables and its fields respectively.


In my form 1st view I have 2 text box fields defined (that belongs to table 1),
that is,
field 1 and field 2
and a button "Retrive details". On click of this button it opens the main connection and pulls the records that was provided in field 1 an field 2.


Now the concern is, whenever I click this button the query takes too much of time (almost a minute) to
pull the records that belongs only to table 1.


I'm thinking whether due to other tables join the query is getting slow down? but other tables are getting used by remaining 2 views of this form.


How can I overcome this kind of performance issue?

Kindly help.


with regards,
Krish TS