Persistence Performance Tips

Persistence Performance Tips


  • Understanding of RDBMS
  • Understanding of JpaQL and SQL.
  • Understanding of ORM
  • A workstation running Windows, Linux, or Mac OS.
  • LDS Tech or other IDE installed.
  • Stack Pet Store Web project installed and ready to use (see section below).
  • Java JDK 1.6+
  • Internet Connection (Specifically to the LDS Pet Store Development Database)

Getting Pet Store Setup

  • Check Out as a Maven Project into your IDE - Pet Store 3.3.1 tag ( )
  • Once you have the pet store checked out, you will want to change your Pet Store Admin Web module in your Tomcat to use the "dev" environment rather than the "local" environment. This change will utilize the pet store dev database rather than having to set up a local oracle database.
  • If you are using LDS Tech IDE you can double click on the stack-pet-store-admin-web-deploy tomcat configuration and change the environment setting on the screen. Save the file and start your tomcat server.

Course Outline

Persistence Performance Tips

  • Persistence Performance Overview
  • Database Performance Tips
  • JPA Performance Tips
  • Spring JDBC Performance Tips
  • Other Tips

SQL Queries to be used in Labs

Several of the labs for this course will involve running queries. To save time, you can copy and paste the following queries to help speed up your lab assignments.

1 explain plan into sys.plan_table$ for select id, name from animal;
2 select  * from table(dbms_xplan.display('sys.plan_table$'));
3 select * from Animal a join Animal_Country ac on = ac.animal_id join Country c on ac.country_id = where like 'Un%';
4 select c.index_name, c.table_name, c.column_name, i.uniqueness, i.index_type from SYS.ALL_INDEXES i join SYS.ALL_IND_COLUMNS c on i.index_name = c.index_name where i.table_name = 'ANIMAL'



This page was last modified on 25 September 2013, at 10:02.

Note: Content found in this wiki may not always reflect official Church information. See Terms of Use.