>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
Hi Sergey,
Thanks for responding. For some reason I never seem to think of using it in the DE.
As it turns out, there's an error in the autoopen method. Now I have to figure out how to reset the autoopen method to default for all the DE's in all the forms.
Thanks,
Trevor