First you have to determine where bottleneck is. You can use Coverage Profiler to do that.
>I have a VFP9SP1 form with 36 cursoradapters in the DE.
>I have tried to improve the load performance of the form by assigning each CA it's own connection to the MSSQL server and have found that 1 connection and 36 connections take the same load time.
>Any ideas how can I improve the load time.
>TIA
>Trevor
--sb--