prepare efficiency? rule of thumb?

From: "tedb@xxxxxxxxx" <tedb@xxxxxxxxx>
Date: 29 Apr 2006 15:02:41 -0700

With MySQL, how much MORE efficient is it to use 1 prepare with
multiple executes (rather than 1 prepare for each execute) when the
perl program runs on the same platform as MySQL? Any idea?

Thanks,
Ted

.

Prev by Date: Re: dbi.perl.org isn't working all that great
Next by Date: RE: DBD::Oracle ppd
Previous by thread: Re: FWD: [dbi] pod patch for ParamArrays and now optional ArrayTupleStatus
Index(es):
- Date
- Thread

Relevant Pages

Re: mysql server has gone away
... > a problem with the perl program itself, but it's the only thing that's ... > i've tried moving code around various places, ... > then all the sql statements are run by doing: ... > and it's the above execute line it says the mysql server's gone away on. ...
(perl.beginners)
Re: faster search engine for fulltext search
... I am using a perl program that searches a MySQL database ... Do you know if there is a faster method available for a perl program? ...
(perl.beginners)
mysql server has gone away
... a problem with the perl program itself, but it's the only thing that's ... i've tried moving code around various places, and the error appears on every ... then all the sql statements are run by doing: ... and it's the above execute line it says the mysql server's gone away on. ...
(perl.beginners)