Hi Chanan,
On Sun, 2 Oct 2011 15:30:00 +0200
Chanan Berler <[email protected]> wrote:
> Hello All,
>
> I am using mySQL 5.1.36, and wonder what are the reasons/usage for
> using prepare_cached above prepare statement when doing SQL queries?
> I am working on none persistent environment, where all request are
> doing connect to db and execute (all http requests are stateless, and
> therefore doing again and again connect to mySQL)
>
> I know (and please correct me if i am wrong) - that cached queries are
> kept only and used only if doing same query all over again and again
> while using same query (using value bind), returning same record set
> using same connection only ?
>
well, if you're going to keep the prepared statement handles somewhere safe
and accessible, and reuse them explicitly, then there is no good reason to use
prepare_cached. Just my 20 agoroth.
Regards,
Shlomi Fish
> Thanks
> Chanan
>
>
>
--
-----------------------------------------------------------------
Shlomi Fish http://www.shlomifish.org/
My Favourite FOSS - http://www.shlomifish.org/open-source/favourite/
No selfârespecting tomboy would use Mandriva.
Please reply to list if it's a mailing list post - http://shlom.in/reply .
_______________________________________________
Perl mailing list
[email protected]
http://mail.perl.org.il/mailman/listinfo/perl
