>>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