|
sqlanywhere_pconnect
Prototype
resource sqlanywhere_pconnect( string con_str )
Description
Establishes a persistent connection to an Adaptive Server Anywhere database. Because of the way Apache creates child processes,
you may observe a performance gain when using sqlanywhere_pconnect instead of sqlanywhere_connect. Persistent connections may provide
improved performance in a similar fashion to connection pooling. If your database server has a limited number of connections (for
example, the personal database server is limited to 10 concurrent connections), caution should be exercised when using persistent
connections. Persistent connections could be attached to each of the child processes, and if you have more child processes in Apache
than there are available connections, you will receive connection errors.
Parameters
con_str A connection string as recognized by Adaptive Server Anywhere.
Returns
A positive SQL Anywhere persistent link identifier on success, or an error and 0 on failure.
Example
This example passes the user ID and password for an Adaptive Server Anywhere
database in the connection string.
$conn = sqlanywhere_pconnect( "UID=dba;PWD=sql" );
Related functions
sqlanywhere_connect
sqlanywhere_disconnect
|