| Bind
Values ( cont. ) |
|
|
|
|
|
|
|
|
|
|
|
| • | The
benefits of this system depend on your |
|||||||||
| underlying
database |
||||||||||
| • | For
Oracle, bind values will work well with the |
|||||||||
| Shared
SQL Cache which result in a pre- |
||||||||||
| prepared
statement handle being reused instead |
||||||||||
| of
the statement being reparsed |
||||||||||
| • | Over
periods of executing the same statement |
|||||||||
| with
different bind values, you will notice a |
||||||||||
| considerable
performance benefit |
||||||||||
| DBI:
The Neophyte's Guide |
| 55 |