in reply to Re: Re: using sequences with dbi
in thread using sequences with dbi

Not to be rude, but why make it more complicated than it is? I have read the links and it looks to like it is mostly personal opinion. When it is something simple and quick I don't use place holders. When it is complicated from the begining then I use place holders. But again that is my personnal opinion.

--BigJoe

Learn patience, you must.
Young PerlMonk, craves Not these things.
Use the source Luke.

Replies are listed 'Best First'.
Re: Re: Re: Re: using sequences with dbi
by tommyw (Hermit) on Oct 04, 2001 at 01:09 UTC

    Because, at the very least, if you run the same program with different parameters, then multiple statements are sent to the server, with different text. This means they have to be reparsed.

    If you use placeholders, then, irrespective of the number of times the statement is executed, the database only ever gets one version of it, but with different parameters. So there's only one parse (which is both faster and more memory efficient for the server).

[reply]

      I think the poster wanted to stress the fact that placehodlers automagically quote the value. If you don't use them (which sounds perfectly fine to me in the conditions you mentioned) you should at least use the quote() method to prevent havoc when an interpolated value contains potentially dangerous characters such as single quotes.

      -- TMTOWTDI

[reply]
[d/l]
Re: Re: Re: Re: using sequences with dbi
by runrig (Abbot) on Oct 04, 2001 at 01:14 UTC
    Whether or not its 'complicated', if you're executing the same statement many times, its more efficient to use placeholders, especially on a database like Oracle, which keeps a SQL cache of its own, so you would benefit even when you only execute the statement a few times, but execute the script many times.
[reply]

In Section Seekers of Perl Wisdom