Databases Reference
In-Depth Information
CHAPTER TWO
Designing your database application and the configu-
ration of the database middleware that connects
your application to the database server for optimal per-
formance isn't easy. We refer to all these components as
your database application deployment. There is no one-
size-fits-all design. You must think about every compo-
nent to get the best performance possible.
Often you are not in control of every component that
affects performance. For example, your company may dic-
tate that all applications run on an application server. Also,
your database administrator most likely controls the data-
base server machine's configuration. In these cases, you need
to consider the configurations that are dictated when design-
ing your database application deployment. For example, if
you know that the applications will reside on an application
server, you probably want to spend ample time planning for
connection and statement pooling, which are both discussed
in this chapter.
9
