>>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.
I've had similar problems using an Oracle back-end. When I change my views to share a connection I get errors when the dataenvironment inits.