>>>I'm using VFP with MySQL database.
>>>
>>>A typical One-to-many form takes 10 connections.
>>>I have checked other app (not VFP) with MySQL only takes 1 connection.
>>>
>>>how can I do the connection pooling in VFP
>>>
>>>thanks for the help
>>>
>>>regards,
>>>
>>>Jerry
>>
>>In my application I am using STRCONNECT() to connect to the MySQL database. The connection handle is saved in the main application object and every form (better data object) is using the same connection handle to execute the queries.
>>
>>Perhaps in your code it does a new connection for each query?
>
>
>in the form.init, I have:
>
>

>store SQLCONNECT(myDataSource,myUserID,myPassword) to thisform.nConnHandle
>

>
>in the form.destroy, I have:
>
>

>SQLDISCONNECT(thisform.nConnHandle)
>

>
>each form will take 10 connections, even the DataEnvironment only has two views.
>
>regards,
>
>Jerry

Perhaps you're using views (which would use the connections as defined in the DBC) ?