Persistent connection
Hi,
I am trying to find a function that will create a persistent
connection. Does connect_cached provide a persistent connection? From
the CLI/ODBC traces, it looks like this program connects two separate
times to the database:
$dbh1 = DBI->connect_cached("dbi:DB2:SAMPLE", "user", "pass");
$dbh1->disconnect;
$dbh2 = DBI->connect_cached("dbi:DB2:SAMPLE", "user", "pass");
$dbh2->disconnect;
How exactly does connect_cached function?
Thanks and regards,
Prashanth Meka
.
Relevant Pages
- Re: Persistent Connection to Speed Performance
... First of all Albert, ... After applying the persistent connection ... The application itself opens quickly either way, it is just the forms I am ... tips to my database some months ago. ... (microsoft.public.access.modulesdaovba) - Persistent connection between FE & BE for better performance
... that I created using the Switchboard Manager. ... that the presence of an .ldb file indicates a persistent connection. ... currently have my database open and see .ldb files for both the BE and FE. ... Am I correct in assuming that because of my switchboard form and related ... (microsoft.public.access.tablesdbdesign) - Re: Sessions and persistent connections to MySQL database
... >persistent connection to the database. ... Not dependant on if it works, I believe the overhead to connect to ... PHP DB Edit Toolkit -- PHP scripts for building ... (comp.lang.php) - Re: Absolutely stumped on front end bloating in Access 2007
... in the BE to force a "persistent connection". ... the database opens, but something tells me I'm not doing it right. ... there obvious form properties that I should be setting or not setting ... (comp.databases.ms-access) - Re: Slow opening local tables in Access 2003
... ensure that you have a persistent connection to the back end database. ... in its OnOpen event and that disconnects from that table in the hidden ... The user never sees the hidden form, ... (comp.databases.ms-access) |
|