Funny you should bring up this subject, as it was recently rehashed
(more like re-re-re-re-hashed!) on perlmonks.org in this discussion
The conclusion of the discussion(s) is that there are valid reasons to
use single and double quotes in various circumstances, and that the CPU
difference due to possible variable interpolation is minor compared to
If performance is a problem for your app, your time would be better
spent profiling your code and address real issues before addressing the
non-issue of variable interpolation.
> -----Original Message-----
> From: Nuno Pereira [mailto:nuno.pereira@stripped]
> Sent: Monday, August 08, 2005 5:04 AM
> To: mysql@stripped
> Subject: Re: How to use Like Clause in Perl? Works fine in
> MySQL control center!
> Knowing not too much from perl, I would like to remember the last
> paragraph of Jeremiah:
> > Keep in mind that interpolation is work, so using one of the
> > single quotes
> > strings which does not search your string for variables to
> > replace is going
> > to be higher performance than the double quoted version,
> although the
> > difference may be a little or a lot depending on how many
> > times the string
> > is interpreted (if it is in a loop or something).
> If performance is a problem, don't forget this.