locked
Infopath - Main Connection Performance issue RRS feed

  • Question

  • 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

    Friday, November 19, 2010 4:52 PM

Answers

  • Hello Krish,

    Thanks for posting. This is a forum for programmers. Your question is more an end-user level question, not a developer (programing) question. You're more likely to find people knowledgeable in this area on the Answers site:

    Microsoft Office for Business Users: Visio, Project, InfoPath, and Access:
    http://social.answers.microsoft.com/Forums/en-IN/addbuz/threads.

    Actually, in this forum, there is also few experts on InfoPath programming issues. Although that answer site is for end-user issues, you will also find more InfoPath specialists on programing issues.

    If you have any concern on this post, just feel free to follow up. Thanks.

    Best regards,
    Bessie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    • Proposed as answer by Bessie Zhao Friday, November 26, 2010 5:02 PM
    • Marked as answer by Bessie Zhao Monday, November 29, 2010 9:13 AM
    Monday, November 22, 2010 7:29 AM