use Perl

• Positional Parameters are a good idea (Score:2)

  by Dom2 (2981) <{dom} {at} {happygiraffe.net}> on 2003.08.07 16:31 (#22872) Homepage Journal

  Not using them means that you have to recreate the query execution plan each time. You get better performance by using them.

  You might want to have a look at Tim Bunce's Advanced DBI talk [gtsm.com]

  -Dom

  Reply to This

  • Re:Positional Parameters are a good idea (Score:1)

    by nkuitse (193)

    Not using them means that you have to recreate the query execution plan each time.
    
    Actually, my code generates SQL with positional parameters. It takes a pseudo-SQL template like this:

    SELECT foo
      FROM bar
      WHERE baz = $baz
       AND qux = $qux

    And turns it into this:

    SELECT foo
      FROM bar
      WHERE baz = ?
       AND qux = ?

    Simultaneously taking the name-based parameters that you provide (in a hash, i.e., unordered) and lining their values up in the correct order in a params