>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?