 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| l |
Optimised Access
Plan etc. is cached within the server
|
|
|
n |
keyed by the
exact original SQL string used
|
|
|
| l |
Without
placeholders, SQL string varies each time
|
|
|
|
n |
so cached one is
not reused
|
|
|
|
n |
and time is
wasted creating a new access plan
|
|
|
|
n |
the new statement
and access plan are added to cache
|
|
|
|
n |
so the cache
fills and other statements get pushed out
|
|
|
| l |
Compare do("insert … $id");
|
|
|
with do("insert … ?", $id);
|
|