Each connection you use takes up resources on the server. I usually try to share a single connection. If you need to run queries asynchronously, you'll need separate connections. I haven't seen any difference with performance, but if everthing has its own connection, you may see faster results as the views could all open at once. This could have pretty serious consequences as far as server resources. This is especially true if you have several users.

If your connection is set for synchronous operation and your views are set to fetch all the records at once, you won't need to worry about the connection being busy. FoxPro will wait for each query to complete.

>>>I am wondering if anyone has any hints on speeding up form instantiation with SYBASE SQL Anywhere as an ODBC client. DBCLIENT is started prior to form instantiation. The form is taking about 12 seconds to appear with 3 tables being loaded with 500,20,20 records respectively. There are 12 other views that have NODATAONLOAD set to TRUE.
>>
>>Hi Steve,
>>
>>Are you sharing the connection in your views. This could make a difference.
>
>4 of the 12 views that have NODATAONLOAD set to TRUE are sharing a connection.
>I have been wondering if there is benefit in sharing connections with all views and if there are drawbacks to doing this. Do you know of any drawbacks with sharing connections? Do I have to put in logic to make sure that the connection is not busy everytime that I want to access the a table on the server?
>
>Thanks for your help