Connection handles and form performance

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Connection handles and form performance

Message

From

04/09/2007 13:24:01

Trevor Hendricks
Paradigm Technologies Corp.
Toronto, Ontario, Canada

All

General information

Forum:

Visual FoxPro

Category:

Client/server

Title:

Connection handles and form performance

Environment versions

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

MS SQL Server

Miscellaneous

Thread ID:

01252263

Message ID:

01252263

Views:

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

Map

View

Click here to load this message in the networking platform