<?xml version="1.0" encoding="windows-1252"?>
<node id="392298" title="Re^3: Tricks with DBI" created="2004-09-20 02:31:59" updated="2005-07-11 18:31:59">
<type id="11">
note</type>
<author id="116292">
mpeppler</author>
<data>
<field name="doctext">
I have to admit that I haven't really tested prepare_cached with DBD::Sybase. I suspect that in certain situations this might still open multiple connections, primarily if DBD::Sybase doesn't realize that a particular query is "finished" before running another one.&lt;p&gt;
If I have the time I'll run a few tests to see what the deal is - and maybe add an override for prepare_cached in DBD::Sybase to avoid any bad surprises.&lt;p&gt;
&lt;b&gt;Update:&lt;/b&gt; After thinking about this a little more, I want to add that with Sybase prepare_cached is really only useful for statements that include placeholders. Any other statement won't really get cached anyway, and doesn't actually get parsed/compiled/optimized until you call DBI's execute().&lt;p&gt;
Michael
</field>
<field name="root_node">
7568</field>
<field name="parent_node">
392104</field>
</data>
</node>
