Using multiple queries in a single data connection? - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Using multiple queries in a single data connection?

Last post 08-03-2010 03:15 AM by ZhenYuan. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 08-02-2010 02:54 AM

    Using multiple queries in a single data connection?

    Hi,

     While creating a form that draws client data from multiple database tables, we realized that we are creating quite an amount of data connections that have to auto retrieve data when the form is launched. As our client data grows and the amount of mapped data connections increase, time taken to load the form increases. So we are wondering if it is possible to use multiple xml queries in a single data connection? This may save us a little webserver <-> database transaction time?

     We are currently using Qdabra Query Builder to form our queries and subsequent data connections. However, this approach only allows us to form a single query per data connection?

     Does anyone have any creative way to perform multiple queries to multiple database tables using a single data connection? We will appreciate any help/ideas greatly!

     

    Thanks a million,

    Zhen Yuan

  • 08-02-2010 05:03 AM In reply to

    Re: Using multiple queries in a single data connection?

    It is possible to use a single data connection for several different QueryDB queries, but this makes form design considerably more challenging because

    1. The secondary data connection's data source will be based off the query you used when initially setting up the data connection.
    2. The contents of the data source will change every time it is requeried, which means you will need to copy the data somewhere else if you intend to use it for more than a very short period of time.

    However, I doubt that going through all that is going to speed up your form much, if at all.  It will make the XSN a little bit smaller, so the initial XSN download will be marginally faster, but if your form is slow from making a lot of queries, making a lot of queries through a single data connection is not going to change that.

     Perhaps your form is performing queries that it does not have to perform when it initially opens?  If there are some queries that only need to run after there is some user input, you can turn off the option to query those data connections when the form is initially opened, and that should speed up your form a bit

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
  • 08-03-2010 03:15 AM In reply to

    Re: Using multiple queries in a single data connection?

    Thanks Jimmy!

     We have streamlined the unneccessary queries to not auto-run when the form is launched but it still takes about 7-8 seconds for the form to load after loading the required data via webservice. Perhaps it's just that we have quite alot of data to retrieve and populate drop-down lists...

     Anyway thanks!

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.